Using FTP in SQL 2000

• sarita Garg

  SSC Eights!

  Points: 824

  More actions

  September 7, 2004 at 11:29 am

  #108825

  I am trying to FTP a file onto SQL 2000 server to load data in the database.  SQL server 2000 DTS allows to FTP using DTS package.  I want to use DTS package to do it so that I can create FTP and data load in the same package.  On the source server file is in a sub folder so when I login thru FTP I see default folder and not the whole path and file that I can select for destination.  Does anyone know how I can accomplish it?  Any help will be greatly appreciated.

  Thank you

• dave007

  SSC Enthusiast

  Points: 105

  More actions

  September 7, 2004 at 12:04 pm

  #522013

  Hi,

  I've done this using the cmdexec feature, and executing ftp using

  ftp -s:filename

  where filename is a text file of commands, just like you'd type into ftp command line. i.e.

  open hostname.com

  user myuser

  mypassword

  cd ftpdir

  get *.zip

  bye

  Give that a try....

  -David

   

• philcart

  SSC-Forever

  Points: 47795

  More actions

  September 8, 2004 at 4:20 am

  #522082

  Use the inbuilt DTS FTP Task.

  If you know the path to the file, you set it statically using Disconnected Edit, or dynamically using Dynamic Properties task.

  --------------------
  Colt 45 - the original point and click interface