Are you executing it from BIDS or scheduling to run it?. Have you looked at package properties to change options to save passwords in the package.
http://databaseandstorage.blogspot.com http://gotodba.weebly.com
Forum Rules