Dynamic password in FTP task in SSIS ?

• blasto_max

  SSCertifiable

  Points: 5025

  More actions

  December 31, 2013 at 4:52 pm

  #286682

  I can set almost all properties of FTP task and FTP connection manager using expressions option. In that option, I don't see that I can set FTP PASSWORD using a variable. How do I set the password dynamically ?

  Thanks.

• Abhijit More

  SSCertifiable

  Points: 6897

  More actions

  January 1, 2014 at 2:24 am

  #1676713

  you can do this by declaring variable. check this post - http://stackoverflow.com/questions/3888170/ftp-connection-string-using-expression-in-ssis

  Abhijit - http://abhijitmore.wordpress.com