Delivery Extension Configuration
The following SFTP Destination delivery extension settings can be modified in the RSreportserver.config
file, located in the main SSRS installation folder. Where additional details are available, hyperlinks to relevant documentation are provided.
Subscription Processing Settings
These settings, used for report subscription processing, are located 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
– Defines the file extension for encrypted files.PGPPublicKeyFolder
– Specifies the directory where PGP public keys are stored. By default, this is the PGPKeys folder inside the ReportServer directory.
See PGP Encryption for more details on EncryptedFileExtention
and PGPPublicKeyFolder
settings.
User Interface Settings
These settings control default rendering options for the UI and are located 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
– Sets the default output format for new subscriptions (e.g., CSV, PDF, Excel).DefaultFieldDelimiter
– Defines the delimiter for text-based formats like CSV.DefaultTextQualifier
– Specifies the character used to enclose text values.
The available rendering formats depend on the installed rendering extensions, which can be found under the <Extensions><Render>
section of the configuration file.
Alternatively, recent versions of the SSRS will list all installed extensions (both Rendering and Delivery) here: [SSRS_WEB_PORTAL_URL]/api/v2.0/Extensions
For example: https://reportingservices/Reports/api/v2.0/Extensions
For a complete list of rendering extensions, refer to Microsoft’s Rendering Extensions Overview.