Included in SSIS PowerPack

SSIS Reporting Services (SSRS) Task

Export or email SSRS reports inside an SSIS package, with or without a report server.

Reporting Services (SSRS) Task, also called the SSIS Report Generator Task, exports or emails SQL Server Reporting Services reports inside an SSIS package. It also supports data-driven export, which exports several reports to disk and emails them to users based on settings stored in a SQL table.

The trial includes Reporting Services (SSRS) Task and every other PowerPack component

SSIS Reporting Services (SSRS) Task: Reporting Services Task - Export Server Report screen
Export or email SSRS reports from SSIS

Trusted by data teams worldwide

MicrosoftIBMOracleDell TechnologiesHPCiscoAT&TVerizonDHLFedExUPSWalmart

Also rated on Capterra★★★★★ , Trustpilot★★★★★ and BBBA+ — see why teams trust ZappySys

At a glance

What Reporting Services (SSRS) Task can do

Reporting Services (SSRS) Task, also called the SSIS Report Generator Task, exports or emails SQL Server Reporting Services reports inside an SSIS package. It also supports data-driven export, which exports several reports to disk and emails them to users based on settings stored in a SQL table.

Export server reports

Export or email SQL Server Reporting Services reports from a report server inside an SSIS package.

  • PDF, XLS, DOC, MHT, HTML, CSV, TIFF or XML
  • SSRS 2005 and higher
  • ReportServiceUrl and ReportPath

Task help

Local reports, no SSRS server

Export an RDL or RDLC file as PDF, XLS or DOC without any Reporting Services setup.

  • Datasets are supplied at runtime by your query
  • DatasetNames, DatasetQueries, DatasetConnectionStrings
  • Or bind a recordset with RecordsetVariable

Task help

Data-driven export

Export many reports to different users in different formats, driven by settings in a SQL table.

  • ConfigTableName with ConfigFilter (e.g. by group name)
  • Last start / end date, status and message are tracked per report

Task help

Email reports as attachments

Send the exported report as an attachment to a list of users.

  • EmailSMTPConnection, To / Cc / Bcc lists
  • Subject and body placeholders like {{ReportName}}, {{ReportDate}}
  • EmailAsHtml for HTML or plain text
  • Server reports can also go out as the HTML email body (see tutorial)

Task help

Report parameters

Pass report parameter values from SSIS variables or as direct values.

  • Multi-value parameters with comma separated values
  • {NULL} and {DEFAULT} values
  • UseDirectValueForParameter

Task help

SharePoint integrated mode

Export reports hosted in SharePoint integrated mode as well as native mode.

  • Use the SharePoint _vti_bin/reportserver URL
  • Paste a report URL and validate it in the UI

Task help

Report server credentials

Connect to the report server with a user name and password or Windows authentication.

  • UserName / Password
  • WindowsAuthentication uses the package’s current credentials

Task help

SQL Server 2012–2025 & ADF

Runs in your environment on SQL Server 2012–2025 and Azure-SSIS.

  • SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit)
  • Azure Data Factory (SSIS IR)
  • Design packages in Visual Studio 2017, 2019, 2022, or 2026
  • Windows only (64-bit OS): Windows 7–11 or Windows Server 2012–2025

Compatibility and requirements

File naming & timeouts

Control where and how exported files are saved.

  • ExportFilePath with a date/time suffix (e.g. _yyyy-MM-dd)
  • GenerateSnapshot after the report runs
  • TimeoutSeconds for report generation

Task help

See all 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 (server reports also HTML and TIFF)
  • Send report as attachment to list of users
  • Support for Data Driven export process with reports, recipients and file format stored in a database table
  • Report parameters from SSIS variables or direct values, including multi-value, NULL and default
  • Bind local report datasets from queries, connection strings or a recordset variable
  • Email subject and body placeholders such as {{ReportName}} and {{ReportDate}}
  • Windows authentication or user name / password for the report server
  • Date/time suffix for exported file names
  • Generate snapshot and set report generation timeout
  • Send a server report as the HTML email body
  • Support for SQL Server 2025, 2022, 2019, 2017, 2016, 2014, 2012 (32/64-bit) and Azure Data Factory

Runs in your environment ·

SQL Server 2012–2025

and Azure-SSIS · Read the FAQ

How it works

From the toolbox to your first run.

Key steps from the Reporting Services (SSRS) Task page and help file, with the screens you will see in SSDT.

Export a report from your report server.

Set Action to Export server report, enter the report service URL (e.g. http://myserver/reportserver) and the report path, then choose file and email output. Paste a report URL from the browser and click the green check to parse it.

  • PDF, XLS, DOC, MHT, HTML, CSV, TIFF or XML
  • SharePoint integrated mode via _vti_bin/reportserver
  • Parameters from SSIS variables or direct values
Reporting Services Task - Export Server Report screen

Inside the UI

Key settings, as they appear in SSDT.

Real screens from the Reporting Services (SSRS) Task product page. Step through them, or open any shot at full size.

Report Generator Task – Export Server Report Mode

Export server report: report server URL, report path, parameters, credentials and file or email output.

Compatibility and requirements

Designed to stay inside your SSIS runtime.

  • SQL Server 2012 through 2025, 32-bit and 64-bit
  • Windows only, 64-bit OS required. SQL Server Express and Web editions do not include SSIS
  • Azure Data Factory SSIS Integration Runtime
  • Self-hosted: credentials and data stay in your environment (external API calls still reach that service)
  • Fully functional 30-day trial of SSIS PowerPack

FAQ

Questions teams ask before they drop Reporting Services (SSRS) Task on the canvas.

What is Reporting Services (SSRS) Task?

Reporting Services (SSRS) Task, also called the SSIS Report Generator Task, exports or emails SQL Server Reporting Services reports inside an SSIS package. It also supports data-driven export, which exports several reports to disk and emails them to users based on settings stored in a SQL table.

Which export formats are supported?

Server reports export to PDF, XLS, DOC, MHT, HTML, CSV, TIFF or XML; the SSRS tutorial also lists Word (.docx) and Excel (.xlsx). Local RDL/RDLC reports export to PDF, XLS or DOC.

Can I export reports without an SSRS server?

Yes. Export local report renders an .rdl or .rdlc file from disk with no Reporting Services setup. Local mode ignores the report’s own queries, so you supply the data at runtime with dataset names, queries and connection strings, or a recordset variable.

How do I pass report parameters?

Map parameters to SSIS variables, or set UseDirectValueForParameter to type values. Names are case sensitive; use commas for multi-value parameters, {NULL} for null and {DEFAULT} for the report’s default.

Can it email the report?

Yes. Enable email output, pick an SMTP connection and enter recipients (separated by semicolons). Subject and body can use {{ReportName}}, {{ReportPath}}, {{ReportParameters}} and {{ReportDate}}. The tutorial also shows sending a server report as the HTML email body.

Can I export many reports in one run?

Yes. Data-driven export reads a SQL config table where each row holds a report, its parameters, export path and recipients. Use ConfigFilter (e.g. GroupName='WEEKLY') to choose which rows run.

Which SQL Server versions can I run it on?

SQL Server 2025, 2022, 2019, 2017, 2016, 2014, and 2012 (32- and 64-bit), plus Azure Data Factory with an SSIS Integration Runtime (packages must target SQL Server 2017). See Compatibility and requirements.

Independent ratings

Trusted by data teams, recognized by the industry

See why teams trust ZappySys (opens in new tab)

What customers say

  • Customer story

    ZappySys has been a fantastic way to bring our small company into the world of APIs, automation, and systems integration by providing tools within an easy-to-use framework.

    Ben KingeryOxspring Paul
  • Customer story

    At Synchronous Customers, we need to connect various types of data quickly. The super handy ZappySys connectors and great documentation let us do it without writing a lot of code.

    Joel ConnerSynchronous Customers
  • Customer story

    I looked everywhere for a product that could integrate to a web portal backend API via JSON. After many attempts, ZappySys was the only solution that gave me all the options I needed in a quick & clean interface within SSIS.

    Maz DunicSave the Children Australia
  • Customer story

    We have worked with the ZappySys support team for over a year and have consistently found them extremely helpful — resourceful and creative in offering multiple solutions to our challenges.

    Senthil SekarPublicis Groupe
  • Trustpilot

    I’ve been using ZappySys for over 6 years — it makes development faster, and I introduced it to my current company.

    Anna JohnsonTrustpilot review
  • Trustpilot

    I’m integrating data from APIs into database tables with SSIS/ZappySys — very easy to use, fast, and highly efficient without writing complex code.

    Carolyn S.Trustpilot review
  • Customer quote

    I submitted a support request and had someone logged in and fixing things within 2 hours.

    Barry Wilson
  • Customer quote

    The REST source is very powerful — the only thing I found I could use after trying components from major vendors.

    Jes KirkupKTC
  • Customer quote

    Whenever we run into an obstacle, ZappySys has a solution for us. We are so glad that we chose ZappySys PowerPack.

    Kevin ChenBerricle

Start your free trial today

Install SSIS PowerPack and drag Reporting Services (SSRS) Task onto the Control Flow.

Export and email SSRS reports from SSIS on demand or after your ETL finishes.

  • Control Flow Task in SSISReporting Services (SSRS) Task appears in the toolbox after you install PowerPack.
  • Fully functional 30-day trialSSIS PowerPack, running in your environment.
  • Live supportHelp during your trial and after purchase.

New purchases may be eligible for refund review within 30 days. See the refund policy.

Talk to an engineer before or during your trial.

1 / 9