rahulsahay123 (8/6/2013)
when running the master package from msdb then the master package is picking all the child packages from sysssispackages tables in msdb.But when trying to run from sqlserver agent it is referring the file system. is there a way by which I can configure this at runtime?
If you run the package manually from MSDB, it runs on your computer, not on the server. That's why you don't get an error, because it can find the packages on your C: drive.
For more info, check out this blog post: Where is my SSIS package executed?
You can change the packages at runtime by using package configurations.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP