We are facing an issue when deploying some packages to the server. Our packages are deployed to File System in SSIS package store.
We have defined a logging connection to MSDB in all packages and use that to log to msdb..sysssislog. Also, a config file(for each package) is used to store the connections and other variables
Problem is, when we schedule the package through a job(using SSIS Package step type) , giving the config file...the package executes but it doesnt log anything to sysssislog.
However, if I right click on the package in the Filesystem store and run it, providing the same config file. It runs and also logs..
We are trying to figure out why it wont log from the job
View Complete Post