I have recently recreated some 2000 DTS packages as SSIS. Essentially I have Five Packages that are executed by one master Package. The packages have all been deployed into SQL Server 2005.
The problem I am having is that when the Master Package attempts to execute the first "Sub Package" it fails; yet if I run the Sub Package independently it runs just fine. On the Master Package I've used File System and MSDB for the connections of
the Sub Packages and I'm still getting the same error. I'm therefore assuming that I need some additional configuration? Can someone please advise.
View Complete Post