SQL Server Performance

Using SSIS Package as datasource

Discussion in 'SQL Server 2005 Reporting Services' started by JLDominguez, Sep 22, 2006.

  1. JLDominguez New Member

    Does 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.

Share This Page