In this article I show you how to create a DTS Package that can be used to automate a file download/import process. It's a little longer than the other articles I have written for SQLTeam and will require some work on your part if you want to implement it, but I think you will find it interesting.
Thanks for a useful and informative article. Can anyone tell me if the Contacts table is overwritten each time the DTS task is run? Can the table be read when the process is running?
Your first requirement was "Connect to an ftp site and download a specific file". How would you handle this if you did not know the name of the file? For example, I need to grab a file every few minutes that has the format cstmtMMDDYYYYHHSSTT.txt. I can't seem to find a way to get the FTP task to allow for filename wildcards or to grab everything in a hot directory. Other than writing a custom ActiveX Script task, do you have any ideas?
I am looking for the same thing. How can i download a file via FTP (in DTS) with a variable name. Like 'name.20050404.zip'.
Hoping that you already found the right answer.
Thanks, Jeroen
quote:Originally posted by lbmouse
Good article. I have a question.
Your first requirement was "Connect to an ftp site and download a specific file". How would you handle this if you did not know the name of the file? For example, I need to grab a file every few minutes that has the format cstmtMMDDYYYYHHSSTT.txt. I can't seem to find a way to get the FTP task to allow for filename wildcards or to grab everything in a hot directory. Other than writing a custom ActiveX Script task, do you have any ideas?
Article: Using DTS to Automate a Data Import Process
Posted - 08/11/2002 : 10:39:23
