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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

running dts from procedure 1

Status
Not open for further replies.
SteveWilson

SteveWilson

Programmer
Joined
Oct 9, 2003
Messages
2
Location
GB
Hi

Does anyone know if it possible to run dts packages from stored procedures, and if so how?

Thanks In advance

Steve
 
Sort by date Sort by votes
Yes it is. One option is to use xp_cmdshell to execute the dtsrun utility and start your package:

Code: 
EXEC master..xp_cmdshell 'dtsrun /Smyserver /E /Nmypackage'

(The /E switch uses a trusted connection to myserver.)

--James
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question Question
Pick up value from combobox
Replies
0
Views
790
bharons
bharons
grnzbra
  • Locked
  • Question Question
GOING FROM DD/MM/YYYY TO MM/DD/YYYY
Replies
4
Views
1K
JeffModen
JeffModen
Auguy
  • Locked
  • Question Question
Move From SQL 2014 Express To Newer Version
Replies
2
Views
392
Auguy
Auguy
eboughey1008
  • Locked
  • Question Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
647
Chris Miller
Chris Miller
bmacbmac
  • Locked
  • Question Question
How to import plain text from Word doc to SQL
Replies
4
Views
724
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top