FTP task

FTP task

Post by Carlo » Tue, 12 Dec 2000 21:34:31


I have a problem with the Ftp task in a DTS Package.
First I select the source Ftp site, the destination path and the files, no
problem with this. But when I execute this step, the file is saved to the
destination path and after that is deleted at the end of the step. I need
that file for later use (next step in DTS)

Any help???




1. DTS FTP Task: Is it possible to get beyond the root directory of the ftp site

You can see sub-directories and navigate up and down but if this is a
virtual directory it will not be shown.

 From "Microsoft Internet Information Server Installation and Planning

"...because of FTPs technical limitations as an older protocol,
virtual directories are not visible to users. Users can enter a virtual
directory only if they know the alias of the virtual directory."

This is an FTP limitation, not the task. You can use Disconnected Edit
to set the file name.

Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

2. equivalent to Oracle tree syntax connect by prior and start with

3. FTP Task - Using "Passive FTP"

4. Dynamic SQL in stored procedures?

5. FTP Task: How Do You Dynamically Change the source file name and Destination File name

6. Managing Uniqueidentifiers

7. FTP Task: filename wildcards?

8. Update sur des réels

9. SQL Server FTP Task

10. FTP Task in DTS (2000)?

11. SQL2000 FTP task only binary ?

12. FTP task in DTS 2000

13. FTP Task - ASCII Transfer