May 5, 2006 at 9:46 am
Does anyone have ideas about how to convert a dts script to a windows service ?
Basically my DTS script runs on a SQL2K (sp4) and does the following:
1. every minute List the content of a directory of XML files
2. Process One file at a time
3. insert data into the DBA
4. delete the file and loop again.
What i wanted to improve is that instead of listing the directoryeach time , i would have prefered to trigger the process when a file is created in the folder ( using something like filesystem watcher ) but also have it registered in windows and started each time the computer runs.
Thanx
May 8, 2006 at 8:00 am
This was removed by the editor as SPAM
May 10, 2006 at 2:24 pm
Theoretically I suppose you could save your DTS job as a vbs file and compile it into and executable. Then you could use the information here http://support.microsoft.com/kb/q137890/ to set it up as a service. I know this is an old doc, but they still write srvany for win 2k3 server and it can be downloaded with the rest of the resource kit here.
-Luke.
May 10, 2006 at 3:46 pm
Thanx, That was basically the type of information i was looking for. Now i have to sort out how to implement a FileSystem watcher within the dts Script...
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply