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 |
|
TSQLMan
Posting Yak Master
160 Posts |
 Posted - 2003-12-23 : 15:12:44
|
| I am trying to call up a DTS Package from a Stored Procedure. What is the syntax? I have tried everything. |
|
|
TSQLMan
Posting Yak Master
160 Posts |
Posted - 2003-12-23 : 15:13:27
|
| Well aparently almost everything. |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2003-12-23 : 15:30:49
|
| I don't know how, but I bet http://www.sqldts.com has the answer.http://www.sqldts.com/?104The last link on that page should help ya!Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2003-12-23 : 15:37:17
|
| One option is to use the dtsrun utility via xp_cmdshell. |
|
|
|
TSQLMan
Posting Yak Master
160 Posts |
Posted - 2003-12-23 : 16:08:09
|
| Thank you all, found what I needed. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2003-12-23 : 16:52:35
|
quote:
Originally posted by TSQLMan
Thank you all, found what I needed.
Just curious, what is your solution? |
|
|
|
|
|
|
Calling DTS from a stored Procedure