Create reports using SSIS - best practice?


  • I want to create a couple of PDF reports from SSIS - from an SQL Server table.  This table contains a list of errors (validation errors).  So when the SSIS error package is called it will create a couple of reports and email them to specific users.

    Should this all be done within SSIS in a script task? Or do you need to use SSRS?  

    Any pointers in the right direction would be greatly appreciated.


    Tuesday, December 11, 2012 2:19 PM


All replies