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

Main02.png

Untitled-9.png

Reports can be sent via email.

Untitled-4.png

Version 1.51 beta

Select a report from SQL Server Reporting Services 2008.

ReportServer.png

Version 1.52 beta

You can now set report parameter via SSIS variables.

report_parameter.png


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.


Last edited Jan 22 at 10:22 AM by Tillmann, version 24

 

Want to leave feedback?
Please use Discussions or Reviews instead.

Updating...
© 2006-2010 Microsoft | About CodePlex | Privacy Statement | Terms of Use | Code of Conduct | Advertise With Us | Version 2010.1.12.16187