dbTalk Databases Forums  

File System Task and FTP Task

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss File System Task and FTP Task in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Oystein@Norway
 
Posts: n/a

Default File System Task and FTP Task - 03-26-2006 , 06:08 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




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.