eelkins
Grasshopper
Points: 20
More actions
July 11, 2002 at 3:07 pm
#173209
Does anyone know how to execute a DTS package from a stored procedure besides using the obvious xp_cmdshell?
Steven.
SSCrazy Eights
Points: 9806
July 12, 2002 at 4:42 am
#432572
You can use the OLE stored procedures to run a dts. See the following link
http://www.swynk.com/friends/green/dtsole.asp
Steven
Robert W Marda
SSChampion
Points: 13413
July 18, 2002 at 5:47 pm
#433050
Another way is to schedule the DTS package and then execute the following system stored procedure in your stored procedure:
sp_start_job
Robert Marda
Robert W. MardaBilling and OSS Specialist - SQL ProgrammerMCL Systems
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply