SSIS Reporting Services Task (SSIS Report Generator Task)

SSIS Reporting Services Task (Report Generator Task)

SSIS Report Generator Task can be used to export or email SSRS reports inside SSIS Package. 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 reporting services report export and email process using SSIS.
  • Support for SSRS 2005/2008/2012 and higher.
  • Support for Local report 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 2005, 2008, 2012, 2014, 2016 (32 bit and 64 bit)

Download Help File Buy
View All Tasks Like This
ScreenshotsUseful LinksSystem Requirements

SSIS Task for Reporting Services – Export server report

SSIS Reporting Services Task - Export Server Report screen

SSIS Reporting Services Task - Parameters screen

SSIS Reporting Services Task - Report credentials screen

SSIS Reporting Services Task - Email export settings screen

SSIS Reporting Services Task - SSRS Report sent as email attachment

SSIS Reporting Services Task - File export settings screen

SSIS Task for Reporting Services – Export local report

SSIS Reporting Services Task - Export Server Report Screen

SSIS Reporting Services Task - Export Server Report Screen

SSIS Task for Reporting Services – Data driven SSRS report export

SSIS Reporting Services Task - Export Server Report Screen

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