I have to pick up some files from an FTP server each day, and want to
automate it. As the files are then loaded into SQL server, I thought the FTP
DTS task would be a good place to start...

From what I can see, to use the FTP task, I need to select the files I want
to transfer. Unfortunately, each new file added to the remote server is given
a unique name, based on the date and time.

Is there any way I can tell the DTS Task to transfer ALL files accross or
better still, just the files which have not already been transferred?

Please bear with me, my understanding of DTS is limited at best, so if I
need to use activex tasks to acheive this, talk slowly... :-)

Thank you

Nick

AFAIK, unless they came out with an update, you are out of luck when it
comes to the stock FTP task. See http://www.sqldts.com/default.aspx?302 and
download their custom FTP task for use as it has greater flexibility. I've
never used it (programmed my own before I found theirs), so you are on your
own there, but the doc looks good. While you are there also see
http://www.sqldts.com/default.aspx?246 to see how to handle if you are going
to be importing more than one file into your DB from the FTP task (can
happen simply by a server crash, internet down, etc). The second has been
the staple of my DTS programming as I do what you do on a regular basis. If
their stock loop doesn't do all you want, let me know. I've modified the
loop quite a bit to accomodate my needs.

I'm not associated with www.sqldts.com, but they have great info, that
cannot be denied.

Scott

"NH" <NH (AT) discussions (DOT) microsoft.com> wrote