Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-11-18 : 08:04:36
|
| CRK writes "I WOULD LIKE RUN A DTS PACKAGE (WHICH IS ON MY SQL SERVER) FROM MY ETL TOOL BY USING STORED PROCEDURECOULD U PLEASE HELP ME ON THISTHANKS" |
|
|
surendrakalekar
Posting Yak Master
120 Posts |
Posted - 2005-11-18 : 09:01:43
|
| It will be better if you provide some detail information about your DTS package and why you want to run it through sp. Is it possible to schedule your DTS package?Surendra |
 |
|
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
Posted - 2005-11-18 : 09:13:00
|
| check out DTSRUN in tsql help________________________________________________Drinking German Beer... fun.Listening to an accordian player play ACDC...priceless |
|
|
|
lizak
Starting Member
12 Posts |
Posted - 2005-11-18 : 09:21:45
|
| See the sample sp below. Be aware you need to understand the security aspects of this approach as it usually stumps people until they figure that out. There are a couple of postings on this topic if you look for them.CREATE PROCEDURE your_stored_procedure ASexec master.dbo.xp_cmdshell 'dtsrun -E -Syour_server -N"your_package"'GO |
|
|
|
|
|
|
STORED PROCEDURE TO RUN DTS PACKAGE