access thread: Running a DTS package via VBA
Message #1 by "Karl Kuellmer" <kuellmer@s...> on Thu, 21 Jun 2001 01:31:29|
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.
Message #2 by "Pamela Bengtson" <pamb@r...> on Wed, 27 Jun 2001 15:09:23|
> I'm using a Access 2000 Project as an interface on a SQL 7.0 database.
> want to make a button to run a saved DTS package. I have written code
> 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 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):
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.
Programming DTS Applications DTS Reference
(c) 1988-98 Microsoft Corporation. All Rights Reserved.
Message #3 by "Pamela Bengtson" <pamb@r...> on Wed, 27 Jun 2001 16:07:08|
Hello again -
I just found this white paper that may help you as well.