SQL Server Performance

ftp -- cd in the source directory

Discussion in 'SQL Server DTS-Related Questions' started by cronid, Nov 17, 2006.

  1. cronid New Member

    I am trying to use the DTS package file transfer protocol to get three files from a remote site. When I go to the files tab, I don't see the files since I need to cd from the root directory on the remote site. But I don't see where on the GUI tabs I can enter the cd command using this method.

    Alternatively, I can get the files if I use the Execute Process Task with an ftp execution where I will include the cd command. Is that the difference between the two methods? Do I have to use the second method or is there a work around for the first method?

Share This Page