Deztec SFTP Destination is a robust delivery extension for Microsoft SQL Reporting Services (SSRS) that streamlines the automated transfer of report subscription outputs to SFTP, FTPS, and FTP destinations. Instead of relying on fragile workarounds—such as exporting reports to network locations, writing custom scripts, or maintaining complex SSIS jobs—Deztec SFTP Destination eliminates unnecessary dependencies and failure points.

Traditional methods for automating report delivery are prone to delays, configuration issues, and security risks. Network paths can become inaccessible, custom jobs require ongoing maintenance, and SSIS workflows introduce additional complexity. Deztec SFTP Destination removes these bottlenecks, allowing SSRS to seamlessly and securely transmit reports to external systems, clients, or storage solutions without manual intervention.

By integrating directly into SSRS, this solution minimizes latency, reduces administrative overhead, and ensures reliable report distribution. Whether delivering reports to stakeholders, regulatory agencies, or third-party systems, Deztec SFTP Destination guarantees fast, automated, and secure delivery—every time.

Multiple Supported Connection Types

SFTP (SSH)

FTPS/FTPES (Explicit TLS/SSL)

FTP (Unencrypted; not recommended)

PGP File Encryption

When enabled, report outputs (CSV, XLSX, etc.) are PGP-encrypted before upload, with a .pgp extension added to the filename.

Self-Contained

Meets the highest security standards for handling sensitive data, including PHI and PCI, while complying with HITRUST, SOC 2, and other rigorous security frameworks. Report output remains securely on the SSRS server, only transferring as part of the intended file delivery process.

Offline Installation Option

Designed for servers with hardened network configurations that block the SSRS server from accessing our licensing service for activation during installation.

Dynamic Filenaming

Customize report file names effortlessly using dynamic date and time variables enclosed in @{}. This ensures consistency and automation in report generation. Placeholders like @{yyyy}, @{MM}, and @{dd} are automatically replaced with their corresponding date values when the report is generated. For a full list of supported date and time format options, refer to Microsoft’s documentation.