Groups | Blog | Home
all groups > sql server dts > january 2007 >

sql server dts : SSIS - process all files in an FTP folder


Charoniv
1/2/2007 3:23:01 AM
How do you process all files in an FTP directory - similar to a for each loop.

I need to be able to download each file and move it to an archive folder on
the ftp site.
Peter W. DeBetta
1/2/2007 1:01:53 PM
If the directory is local, you can use a ForEach Loop Container and a File
System Task in that conatiner to move the files.

If not, could you be a little more specific about where the files are and to
where they need to be moved...

--
Peter DeBetta, MVP - SQL Server
http://sqlblog.com
--
[quoted text, click to view]

Charoniv
1/2/2007 8:26:00 PM
Thanks for the comment but the files are on an ftp site which we can only
access via ftp and need to move them to a local folder.
If they were on a local folder there wouldn't be a problem.
Also wouldn't be a problem if we knew the file names.

The basic problem is:
for each file on the ftp site download the file to a local folder then move
it to an archive directory on the ftp site.

Not a problem using dos, VB, t-sql, .net etc. but we want it contained
within SSIS and hopefully without a custom task. We cannot hold passwords on
disk (but can in a database which I guess security don't realise is held on a
disk).





[quoted text, click to view]
AddThis Social Bookmark Button