Viewing 2 posts - 1 through 2 (of 2 total)
I think I would use a script task to do that.
something like this: hope it helps:
Dim cm As ConnectionManager = Dts.Connections.Add("FTP")
cm.Properties("ServerName").SetValue(cm, "ServerNamehere")
cm.Properties("ServerUserName").SetValue(cm, "ServerUserNamehere")
cm.Properties("ServerPassword").SetValue(cm, "ServerPasswordHere")
cm.Properties("ServerPort").SetValue(cm, "ServerPortHere")
cm.Properties("Timeout").SetValue(cm, "TimeoutHere") '0=no timeout
cm.Properties("ChunkSize").SetValue(cm, "1000") '1000...
June 18, 2010 at 4:32 pm
wow i read thru this thread looking for info on a looping ftp task and i realized that lots of posters dont understand the password security built into SSIS. Basically...
March 15, 2010 at 9:39 pm
Viewing 2 posts - 1 through 2 (of 2 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy