I'm trying to trigger a DTS package from within VBA. I've had a look through the DMO object tree but can't figure out how to do it (or if I'm looking in the right place) Any pointers would be a great help
Cheers Ste
Mon, 03 Mar 2003 03:00:00 GMT
Darren Gree #2 / 2
Triggering a DTS package from VBA
Quote:
>I'm trying to trigger a DTS package from within VBA. I've had a look >through the DMO object tree but can't figure out how to do it (or if I'm >looking in the right place) >Any pointers would be a great help
>Cheers >Ste
You can do it from SQL-NS or using the DTS Package Object Library, but not DMO.
http://www.swynk.com/friends/green/ExecDTS.asp
-- Darren Green SQL/DTS - http://www.swynk.com/friends/green/
Triggering a DTS package from VBA