Poll directory using DTS

[MDA]

Hi all,

Is it possible to poll a directory for a particular file using DTS. I have a transaction file that is put into a directory at different times throughout the month. This file needs to be uploaded to a database, if it exists. Then the file has to be moved to another directory(history)if the upload is completed without errors.

Any ideas on how to do this are greatly appreciated.

Regards,
MDA

 

[topher0303]

You can use the Scripting object to determine if a file exists and moving it to other directories.

http://msdn.microsoft.com/library/d...-us/script56/html/sgFileSystemObjectModel.asp

 

[tlbroadbent]

See the article "Looping, Importing and Archiving" at the SQLDTS website. You should be able to modify the code to meet your needs.

http://www.sqldts.com/default.aspx?6,103,246,0,1

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm