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)