ACC'97 VBA execution of a SQL SRVR 7 DTS package

[vern.degeus]

HI:
i need use an ACCESS'97 module written in VBA to execute a
DTS package on a SQL Server 7 Instance:
i am getting all balled up in the object model that the
references regarding DTS packages to ACCESS are exposing;
would someone plse explain the object model ? (sample code
would be very welcome..)
thank you

 

[Paul Overway]

You might find it easier to create a stored procedure that executes your DTS
package, and then create a pass through query in Access to run your stored
procedure.