SSIS Reporting Services Task (SSIS Report Generator Task)

SSIS Report Generator Task (Export SSRS Reports)

SSIS Report Generator Task can be used to export or email SSRS reports inside SSIS Package (i.e. SQL Server Reporting Services). This task also supports dynamic data driven export which can export several reports to disk and email to specified users based on settings stored in sql table.

Features

  • Automate / Call reporting services report export and email process using SSIS.
  • Support for SSRS 2005 and higher (e.g. 2008, 2012).
  • Support for Local report mode which requires no connectivity to SSRS server, just provide rdl file and runtime connection to export report.
  • Support for Sharepoint Integrated Mode.
  • Export report in xls, pdf, doc, xml, mhtml and csv format
  • Send report as attachment to list of users
  • Support for Data Driver export process. You can configure reports, recipients, file format and many other options inside Database table to drive your automated export process
  • Support for SQL Server 2022, 2019, 2017, 2016, 2014, 2012 (32/64 bit) and now Azure Data Factory
See also
Custom SSIS Tasks - Export JSON File Task Export JSON File Task
Custom SSIS Tasks - Call REST API Webservice (GET, POST, DELETE etc) REST API Webservice Task
Custom SSIS Tasks - XML Source (File, SOAP, REST API) XML Source (File, SOAP, REST API)
Download Help File Buy View All Tasks Like This
ScreenshotsUseful LinksSystem Requirements

SSIS Repor Generator Task – Export Server Report Mode

SSIS Reporting Services Task - Export Server Report screen

SSIS Repor Generator Task – Export Local Report Mode

SSIS Reporting Services Task - Export Server Report Screen

SSIS Repor Generator Task – Data-driven Mode (Settings from SQL Table)

SSIS Reporting Services Task - Export Server Report Screen

Create Config Table for Data-driven Mode

SSIS Reporting Services Task - Export Server Report Screen

Output Settings for SSRS Report

SSIS Reporting Services Task - File export settings screen

Call SSRS reports with parameters in SSIS

SSIS Reporting Services Task - Parameters screen

Pass credentials for SQL Server Reporting Services in SSIS

SSIS Reporting Services Task - Report credentials screen

Send SSRS report as an email attachment in SSIS (i.e. PDF, Excel, HTML Format)

SSIS Reporting Services Task - Email export settings screen

Export / Send SSRS report as PDF Email attachment in SSIS

SSIS Reporting Services Task - SSRS Report sent as email attachment

SSRS Report Preview

SSIS Reporting Services Task - Export Server Report Screen

 

Click here to learn more about System Requirements
Download View All Tasks Like This