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 |
|
kmistic
Starting Member
40 Posts |
 Posted - 2005-03-07 : 16:49:03
|
| I have a stored procedure that is failing and i can't figure out what to do. Below is the the SP along with the error message i receive. CREATE procedure dbo.execdts as DECLARE @CMD varchar(100)SET @CMD = 'DTSRun /S "FINC01" /U "reportuser" /P "password" /N "HDPOLines" /G "{1DABCA1E-C004-4F56-8E6F-00AB41C34F29}" /W "0"' exec master..xp_cmdshell @cmdGOerror:DTSRun: Invalid command options Usage: dtsrun /option [value] [/option [value]] ... Options ('/?' shows this screen; '-' May be substituted for '/'): Package retrieval: /~S Server Name /~U User Name /~P Password /E <Use trusted connection instead of /U /P> /~N Package Name /~M Package Password /~G Package Guid String /~V Package Version Guid String /~F Structured Storage UNC filename (overwritten if /S also specified) /~R Repository Database Name <uses default if blank; loads package from repository database> Package operation (overrides stored Package settings): /~A Global Variable Name:typeid=Value <may quote entire string (including name:typeid)> /~L Log file name /~W Write Completion Status to Windows Event Log <True or False> DTSRun action (default is to execute Package): /!X <Do not execute; retrieves Package to /F filename> /!D <Do not execute; drop package from SQL Server (cannot drop from Storage File)> /!Y <Do not execute; output encrypted command line> /!C <Copies command line to Windows clipboard (may be used with /!Y and /!X)> Notes: ~ is optional; if present, the parameter is hex text of encrypted value (0x313233...) Whitespace between command switch and value is optional Embedded whitespace in values must be embedded in double-quotes If an option is specified multiple times, the last one wins (except multiple /A) NULLThis command line works from a command promt and it also works using dtsrunui. |
|
|
scrap
Yak Posting Veteran
57 Posts |
Posted - 2005-03-07 : 16:56:44
|
| Maybe your answer is in "wrong sentence" a few lines below. |
 |
|
|
nosepicker
Constraint Violating Yak Guru
366 Posts |
Posted - 2005-03-07 : 17:59:39
|
| Your @CMD string is longer than 100 characters. Change your variable definition to something like varchar(200). |
|
|
|
|
|
|
stored procedure failing with @cmdshell command