SSIS drops passwords from tasks

Question

SSIS drops passwords from tasks

Martin Vrieze

SSCrazy

Points: 2760
More actions
July 16, 2007 at 7:26 am

#117774

Is it just me or does SSIS look for ways to drop passwords when publishing to production?
I published an SSIS job that I've tested extensively in development.
SSIS appears to have lost the FTP password so the job fails. Job logging is impossible to decipher...MS made that hopelessly difficult for the average guy to interpret.
I went back, ran the job in development mode. The password is there and the job ran flawlessly.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Tim Mitchell SSCoach Points: 15695 More actions · Answer 1

How are you storing the password? If you're not doing so already, store it in a config file for maximum portability. See the following for a primer on how to do this:

http://www.nigelrivett.net/DTS/SSISConfigurationFile.html

hth

Tim

Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices

Martin Vrieze SSCrazy Points: 2760 More actions · Answer 2

This looks like a very good solution. I was looking for an expression that could take the password from a variable but there is none for the FTP Connection.

A file-based solution will work just fine.

Martin Vrieze SSCrazy Points: 2760 More actions · Answer 3

Tim,

Your solution worked perfectly in development and I've published it to the production server.

Thanks!!!

Tim Mitchell SSCoach Points: 15695 More actions · Answer 4

Glad to help... best of luck to you.

Tim

Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices