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

  • Thread starter Thread starter vern.degeus
  • Start date Start date
V

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
 
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.
 
Back
Top