Ftp task in DTS

• abaig

  Old Hand

  Points: 364

  More actions

  July 29, 2003 at 8:51 am

  #159824

  Hi everyone,

  I am getting the following message when I am trying to setup an ftp task in dts.

  "Unable to connect to internet! Please check the source site information, your username and password." What I am trying to accomplish is to get the text files periodically from the sql2k server and put them on the ftp site using ftp task. The connection was tested and it worked fine via IE or any ftp tool but no luck when setting up the ftp task.

  Any ideas or suggestions?

  Thank you.

• August 1, 2003 at 8:00 am

  This was removed by the editor as SPAM

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  August 1, 2003 at 9:42 am

  #468246

  The DTS task only downloads files, it doesn't upload them.

  I've got a script that can help you to put things out there.

  http://www.sqlservercentral.com/columnists/sjones/pushftp.asp

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  http://www.dkranch.net