Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Problem with FTP Task in SSIS on SQL2005

    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...

  • RE: Problem with FTP Task in SSIS on SQL2005

    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...

Viewing 2 posts - 1 through 2 (of 2 total)