Project DescriptionSSIS Task for SQL Server 2008 and 2012 to create server reports or local reports from a recordset data source.
Functions:
- 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

You can find more screenshots on my blog:
http://ssis-components.net/page/SSIS-ReportGeneratorTask.aspxWhen you are looking for more SSIS Tasks please visit my german blog
http://www.ssis-components.net (
Components).