I'm using a Access 2000 Project as an interface on a SQL 7.0 database.  I 

want to make a button to run a saved DTS package.  I have written code to 

run stored procedures in VBA, but can't figure out how to run a DTS 

package.  Right now, when they need it, they email me and I run it for 

them from Enterprise Manager.



Any ideas?

> I'm using a Access 2000 Project as an interface on a SQL 7.0 database.  

I 

> want to make a button to run a saved DTS package.  I have written code 

to 

> run stored procedures in VBA, but can't figure out how to run a DTS 

> package.  Right now, when they need it, they email me and I run it for 

> them from Enterprise Manager.

> 

> Any ideas?





Hello -



I am also trying to learn more about DTS and I just happened to be reading 

a page in the SQL BOL that may steer you in the right direction.  I've 

copied this from the BOL (book on line):



Component Interface

As an alternative to using SQL Server Enterprise Manager, you can use the 

DTS COM interface to create and execute packages. One advantage of using 

the DTS COM interface is that you can create custom applications (using 

Microsoft® Visual Basic®, C++, Visual Basic Scripting Edition, or 

Microsoft JScript®) that allow you to extend the capabilities of DTS by 

defining customized transformations using DTS package, DTS scripting 

objects, and DTS Data Pump interfaces.



The DTS API is designed to maximize the extensibility of DTS by allowing 

the addition of connections, tasks, and objects to a package. The Package 

object has collections for Connection, Task, and Step objects. New objects 

can easily be added to these collections to extend the processing 

performed by the package.



See Also

Programming DTS Applications DTS Reference 





(c) 1988-98 Microsoft Corporation. All Rights Reserved. 

Hello again -



I just found this white paper that may help you as well.

http://www.microsoft.com/office/sup/support.asp?

lu=6&prd=access&pg=highlights/acc2000.asp