SSIS ReportGeneratorTask

Project Description
SSIS Task for SQL Server 2008 to create Reports from a recordset data source.

Functions:

• Reports can save with date and time as prefix
• Render local reports (recordset)
• Render reports as Adobe Acrobat (PDF)
• Render reports as Microsoft Excel
• Show reports during execution

Version 1.51 beta:

• Render remote reports (SQL Server Reporting Services 2008)

Version 1.51 only support windows authorization and does not support parameters.

How to generate reports:

1. Create a local report (*.rdlc) with Visual Studio
2. Create a SSIS package and store data in a recordset (local package var). The schema must the same as in your report.
3. Define parameter in "Task 'ReportGenerator'"
   1. Report: local report or remote report (SQL Server Reporting Services 2008)
   2. Variable: Name of the package variable where the recordset is stored
   3. Report: Path to the local report
   4. Dataset Name: Name of the dataset used in the local report (read from report in version 1.51)
   5. Save as: Path to save the file
   6. Prefix Filename: stores the filename with prefix in a variable
4. Run the package

Reports can be sent via email.



Version 1.51 beta

Select a report from SQL Server Reporting Services 2008.



Version 1.52 beta

You can now set report parameter via SSIS variables.




When you are looking for more SSIS Tasks please visit my german blog http://www.ssis-components.net or my employers website datenfabrik who develops different data quality components for SQL Server Integration Services.