Is it possible to execute a DTS package as a particular event occurs?
Posted on 2005-05-06
I'm working on the following task
One of the current application exports a file in the text file format to a specified directory. As soon as the file arrives in a specified directory the process should start which will import data from a text file to a SQL server table and then move that text file to a 'processed' directory. After the import part is completed successfully a report is generated in the text file format in a particular directory and then the report is mailed to muliple users.
I'm thinking of a DTS package for this functionality. But then I don't want to schedule the DTS package but the package should be executed only when a new file arrives in the specified directory.
Is it possible to execute a DTS package as a particular event occurs? Or is there another way to do this like using VBScript calling DTSRun etc?
Thanks for the help.