Hello,
I've built a package and have been following the mdsn guidelines
http://support.microsoft.com/kb/918760
Method 4: Use SSIS Package configuration files
and DontSaveSensitive, etc.
The method usually works fine.
But this one package runs locally in my BIDS,
but since deploying it can only be run by term serv-ing
onto the server and running the package from the file system.
It will not run from SQL Manager Studio/Integration Server remotely or in a job.
It errors out on the login for the OLEDB connections, the login is fine and
there are no errors when I double clickon the package file itself
and run it in SMS directly on the server.
Pardon me if this is a re-post, all the related mentions I found here did not seem
to fit this exactly and refer to that MSDN fix we already implemented.
Thanks everyone!