SQL Server Performance Forum – Threads Archive
Using SSIS Package as datasourceDoes anyone have a good refrence for setting up an SSIS package stored in MSDB as a datasource. Some that describes the security setup for running one of these from MSDB. I currently have a report that uses a store package but keep getting "failure to validate" error. However, when I open it in BIDS, it works fine. The SSIS package is merging data from and Excel SP and an sql table-if that makes any difference.