Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Kick of a DTS package from Access 97
- Thread starter joshs1100
- Start date
tlbroadbent
MIS
I've not tried this but you should be able to use the DTS Package Object Library in VBA. Add reference to the Object Library and create a module similar to the one described in the Visual Basic example at SQLDTS.com.
You could also write a stored procedure to start the package. See some sample code at ...
You can also Shell to DTSRUN.EXE from Access. DTSRUN.EXE is documented in SQL BOL.
Another option create a Job that runs the package and start the job by executing the stored procedure sp_startjob. You can also start jobs using SQLDMO if you're interested in analyzing all the options. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
You could also write a stored procedure to start the package. See some sample code at ...
You can also Shell to DTSRUN.EXE from Access. DTSRUN.EXE is documented in SQL BOL.
Another option create a Job that runs the package and start the job by executing the stored procedure sp_startjob. You can also start jobs using SQLDMO if you're interested in analyzing all the options. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.
- Status
