October 13, 2015 at 5:38 pm
Thank you John!
Within my foreach loop I have the FTP Task only, to confirm is this what you mean by data task? All I have in the for loop is the ftP task and just want to make sure I am not missing a step.
I have also added the breakpoints as you have recommended. This works great. My values are passing correctly. I am now getting the message, " Connection manager "FTP Connection Manager": An error occurred in the requested FTP operation. Detailed error description: The password was not allowed"
This happens when:
1.) I try adding these expressions individually "ServerName" and "ServerUserName". I do not see a value for "ServerPassword".
2.) Also When I try to concatenate the complete string to the ConnectionString: @[User::FTPServer] + ":21." + @[User::FTPUser] + "." + @[User::FTPPwd]
October 14, 2015 at 1:03 pm
I have solve the no password issue by changing the Package Protection Level from EncryptSensitiveWithUserKey to EncryptAllWithPassword then creating a new password in the PackagePassword field.
Thank you John!
October 15, 2015 at 7:05 am
So my new challenge is when I have multiple records returned for my For Each Loop, I now get the "The password was not allowed." error message again.
To solve this I needed to create a Script Task to be able to pass the password information. The following article was very useful to setup the script task using C#:
http://www.ideaexcursion.com/2008/11/24/set-ftp-password-in-ssis/
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply