Project Description
SSIS Task for SQL Server 2008 and 2012 to create server reports or local reports from a recordset data source.

  • Render local reports (recordset)
  • Render remote reports (SQL Server Reporting Services 2008 and 2012)
  • Render remote reports from SharePoint 2010
  • Render remote reports from SQL Azure Reporting
  • Reports can save with date and time as prefix
  • Render reports as
    • XML file with report data (XML)
    • Comma Delimited (CSV)
    • Acrobat (PDF)
    • HTML 4.0 (HTM)
    • Web Archive (HTM)
    • Office Excel (XLS)
    • TIFF file (TIFF)
    • Office Word (DOC)
  • Show reports during execution
  • Generate snapshots
  • View server report properties during configuration
  • Set report parameter via SSIS variables

The new version is only for SQL Server 2012.
The new Version 1.7 includes rendering from Microsoft SharePoint and SQL Azure Reporting.
The component for SQL Server 2008 is planned for end of November.

To connect to SharePoint, use the following URL:

http://<YOUR SERVER>/_vti_bin/ReportServer

ReportGeneratorTask Configuration Report Parameter Configuration Report Server Properties Report Properties - General

You can find more screenshots on my blog:

When you are looking for more SSIS Tasks please visit my german blog (Components).

Last edited Oct 30, 2012 at 12:45 PM by Tillmann, version 38