DTS question

[dgillz]

Using DTS, is it possible to have MS SQL Server go out every 10 minutes or so and check for the existence of a certail file, and if it is there, convert the data and append it to an existing SQL database?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[JohnDTampaBay]

You can schedule a DTS package to run at any interval you like. Use an ActiveX script within the DTS package to check for file existence and proceed accordingly. Here's a link that will help with the ActiveX script.

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

Good luck!

--Angel
-----------------------------------
Every time I lose my mind, I wonder
if it's really worth finding.