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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS FROM SP

Status
Not open for further replies.

moleboy

IS-IT--Management
Oct 10, 2002
33
GB
HI,

Is is possible to call a DTS package from a stored procedure??

Cheers
Moley
 
That was for v7 really.
With 2000 you can set global variables with dtsrun (an use them in that package from a dynamic properties task) so that technique's not so useful. Easier just to use dtsrun now.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top