Triggering a DTS package from VBA 
Author Message
 Triggering a DTS package from VBA

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
 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/



Mon, 03 Mar 2003 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Calling DTS package from VBA can't find package

2. SQL7 DTS package->VBA

3. DTS package with 2 data pumps gets automation error in VBA

4. VBA to Execute DTS Package

5. Uninitialize DTS-Package in VBA (Access 2000)

6. DTS package execution with VBA - Error numbers different

7. Run a DTS package from another DTS package

8. DTS package not executing an inside DTS package

9. Calling DTS package from DTS package

10. Running DTS Packages from a DTS package

11. Execute DTS Package within another DTS Package

12. Referencing DTS package name from within the DTS package


 
Powered by phpBB® Forum Software