SFTP Password variable

[naters...@gmail.com]

Hello,

I am new to SSIS and I have created a project to download some files from an sftp server periodically. An issue I have come across is the password for the SFTP changes monthly. Is there a way I can load the password as a variable and change it from another source?

[Ivan Peev]

Hi,

You can load the complete ConnectionString property for the connection manager dynamically from a configuration file and you can specify the updated password there.

[naters...@gmail.com]

It would be great if I could write a script task like this

 http://www.ideaexcursion.com/2008/11/24/set-ftp-password-in-ssis/

Does anyone know what properties I would load for a SFTP task?

[Ivan Peev]

You don't need to write script to setup the ConnectionString property. Just create configuration which setups the connection manager property from outside.