Delivery Extension Configuration

Some SFTP Destination settings can be adjusted in RSreportserver.config within the SSRS installation folder.

Subscription Processing Settings

These values are under <Extensions><Delivery> :

<Extension Name="Deztec SFTP Destination" Type="Deztec.SFTPDestination.SFTPDeliveryProvider, Deztec.SFTPDestination">
    <MaxRetries>3</MaxRetries>
    <SecondsBeforeRetry>900</SecondsBeforeRetry>
    <Configuration>
        <RSSFTPDestinationConfiguration>
            <EncryptedFileExtention>.pgp</EncryptedFileExtention>
            <PGPPublicKeyFolder>C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\PGPKeys\</PGPPublicKeyFolder>
        </RSSFTPDestinationConfiguration>
    </Configuration>
</Extension>

• EncryptedFileExtension — file extension applied to encrypted output.
• PGPPublicKeyFolder — default location for PGP public keys.

See PGP Encryption for more details about the EncryptedFileExtension and PGPPublicKeyFolder settings.

User Interface Settings

Default UI values are under <Extensions><DeliveryUI> :

<Extension Name="Deztec SFTP Destination" Type="Deztec.SFTPDestination.SFTPDeliveryUIControl, Deztec.SFTPDestination">
    <DefaultDeliveryExtension>False</DefaultDeliveryExtension>
    <Configuration>
        <RSSFTPDestinationConfiguration>
            <DefaultRenderingExtension>CSV</DefaultRenderingExtension>
            <DefaultFieldDelimiter>,</DefaultFieldDelimiter>
            <DefaultTextQualifier>"</DefaultTextQualifier>
        </RSSFTPDestinationConfiguration>
    </Configuration>
</Extension>

• DefaultRenderingExtension — default output format for new subscriptions.
• DefaultFieldDelimiter — delimiter used for text formats such as CSV.
• DefaultTextQualifier — character used to enclose text values.

Available output formats depend on the rendering extensions installed in SSRS, which are listed under <Extensions><Render> in the configuration file.

Recent SSRS versions also list installed rendering and delivery extensions at [SSRS_WEB_PORTAL_URL]/api/v2.0/Extensions. For example: https://reportingservices/Reports/api/v2.0/Extensions.

For a complete list of rendering extensions, see Microsoft’s Rendering Extensions Overview.