MS SQL Server DTS - File System Task and FTP Task

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

File System Task and FTP Task

Oystein@Norway

2006-03-26, 8:27 pm

Hi!
Q1. I want to FTP .txt files from a remote server(1) to a local server(2)
and then ship it to another server(3). When a new file has been FTP'ed to (2)
it will automtically be FTP' to (3). The file at (2) will be moved in a
folder(4). At the next FTP from (1) it should only get the files which is not
in folder(4).

What is the best way to do that lookup in folder(4) from a FTP Task.?

Q2. File System Task. I've tried, in the same example as above, to move a
file from a variable location(c:\inbox\*.Done) to destination (c:\outbox).
But I get a errror when executing the task."Illegal characters in path".
How does a variable path in File System Task look like?

Thanks,

Oystein

Sponsored Links