I want to know how to execute an existing SQL Server DTS package from within
Microsoft Access 2000. Let's say I have an Access form with one control on
it, a command button, and I want to execute the package when the button is
clicked. Let's call my SQL Server "SERVER1", my database within that server
is called "Joe", and my DTS package is called "Bozo". I'm trying to keep this
as simple as possible, just so I can get the "basics" down pat. Any help
would be greatly apperciated.

You will need the DTS dlls on the box that does the calling

Redistributing DTS with your program
(http://www.sqldts.com/default.aspx?225)


You can then call your package similar to

Execute a package from Visual Basic (VB)
(http://www.sqldts.com/default.aspx?208)



Allan


"JDGUILTY" <JDGUILTY (AT) discussions (DOT) microsoft.com> wrote