SFTP Destination

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.

Back to SFTP Destination

Share your love