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 2017, 2016, 2014, 2012, 2008 (32/64 bit) and now Azure Data Factory

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

 

  • .net framework 3.5 or higher must be installed
  • SSIS Runtime: To execute SSIS package you will need one or more versions of SQL Server Integration Services 2005/2008/2008 R2/2012/2014 or 2016
  • To design SSIS 2012 package SSDT (VS 2010 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2014 package SSDT-BI (VS 2013 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2016 package SSDT-BI (VS 2015 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2005, 2008, 2008 R2 packages BIDS (VS 2005,2008 Shell – Business Intelligence Development Studio) must be installed.
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1
  • Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2
Download View All Tasks Like This