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 - 2001-06-01 : 11:19:12
|
Blair writes "I'm trying to build a stored procedure to run a DTS package. After reading many manuals and reviewing the help file, it seems that the only way to do this would be to use xp_cmdshell to run DTSRun.exe.
I'm having problems getting xp_cmdshell to launch DTSRun and am not sure where the problem lies. Here is an example of what happens when I just try to run it in Query Analyzer:
I'm entering:
EXECUTE MASTER.dbo.xp_cmdshell 'DTSRun.exe /S ServerName /U UserName /P Password /N PackageName'
My results are:
NULL
I get the same results if I also use the following:
EXECUTE MASTER.dbo.xp_cmdshell 'DTSRun /S DELAWARE\DELAWARE2000 /U bskidmore /P password /N ACT_Batch_All_Data /G {C364419C-48FA-4499-B900-B4D9287FA26A}'
Can you help? Thanks." |
|
|
|
|
|
Running a DTS Package with xp_cmdshell in a Stored Procedure