Actually, there's back-door that has nothing to do with VB or COM... -In enterprise manager, right click on your DTS, and choose "Schedule Package"
-Now schedule the Package for any time period. -On the root tree for that DB server, go to "Management / SQL Server Agent / Jobs" -Right click on the job you just created, and go to "Properties" -2nd tab over is "Steps", go there -Double click on the step you see, and there you'll see a command window with a command like this "DTSRun /~Zfdajkl;fjakf;s1359013u5rjfda;slf" this will be the unique command line for your DTS job. Paste it in a text file, and call it it "c:\DTS.bat" now you can do: <cfexecute name="c:\dts.bat" outputFile="c:\dts.log" timeout="600"> and that is that. -Jeff ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
