FTP task

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

Hi:

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???

Thanks

Carlos

Top

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
Guide"-

"...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 ?