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 |
|
DeveloperIQ
Yak Posting Veteran
71 Posts |
 Posted - 2009-02-03 : 13:25:30
|
| My job has the following StepDTSRun /SPRODDB/E /NStaging_Load_ACTAnd is failing with the following error. Can anyone suggest what could be wrong. The Account DOMAIN\SQLUSER is a sysadmin and part of Administrators group and the agent is running under this account.Executed as user: DOMAIN\SQLUSER. ...me or trusted connection. 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. The step failed. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-02-03 : 13:55:35
|
See here for an easy way:http://www.sqldts.com/301.aspxWebfred
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
DeveloperIQ
Yak Posting Veteran
71 Posts |
Posted - 2009-02-03 : 14:07:20
|
| Thanks for pointing to the right direction. I discovered that I needed double quotes around package and server names for it to work. They work fine on another server without one. I wonder what changed with this server. Both are SQL 2000 |
|
|
|
|
|
|
Weird DTS Error