Clever Geek Handbook

SQL Server 2000 FTP Server

I am trying to use the SQL Server 2000 DTS package to download a file from an FTP server. However, the FTP module in DTS only shows files in my ftp login home directory. I need to change the remote directory as soon as I connected. How should I do it? I am rather happily browsing the directory in the Files tab of an FTP task. The directory I need to browse is "above" my home directory.

Many thanks.

0


source to share


1 answer


Add a "dynamic property task" one step before the FTP task.

Change the FTP task setting for SourceFilename. It's just a constant.



The initial value should be: 'FileName'; '/ FTPSTARTUP / PATH'; 'FILESIZE'

+1


source






More articles:


All Articles