January 10, 2012 at 9:30 am
Could someone please shine a light for me on this one?
I have a SSIS 2005 solution that contains two Packages.
One package has a task to call the other one. Package1 calls Package2 for example.
When I run Package2 all by itself, the FTP task executes perfectly and package execution is a success.
When I run Package1, it fails on FTP task in Package2, stating that "The password was not allowed".
Both packages have ProtectionLevel set to EncryptSensitiveWithPassword, where passwords are exactly the same for both packages.
Any ideas are greatly appreciated.
Thank you!
January 10, 2012 at 9:39 am
It should work for you...
http://www.ideaexcursion.com/2008/11/24/set-ftp-password-in-ssis/
January 10, 2012 at 10:11 am
Worked like a charm!!!
Thank you!
p.s. Do you think it's OK to store a FTP password in a variable? No compliance issues here?
January 10, 2012 at 12:17 pm
Depends on what you are trying to comply with.. And you might switch to EncryptAllWithPassword then you'd have to have the PW to even open the package.
CEWII
January 10, 2012 at 1:25 pm
I get prompted for a password when I open the package even with EncryptSensitiveWithPassword.
January 10, 2012 at 2:31 pm
True, but since a password in a variable would generally not be considered sensitive it is probably in the SSIS package code in clear text..
CEWII
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply