sql server dts: Hi everyone,
I used this command to run a package: dtsrun /S "local"/N "leitest1"

The job failed. I got this error message:

Executed as user: Main\jih. ...version guid, or a source filename. 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... Process Exit Code 1. The step failed.

I think my syntax is right. But why the error message says that it is not?

Thanks,

Hello pelican,

local when used like this should be (local). localhost would work though

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

[quoted text, click to view]
False>> DTSRun action (default is to execute Package): /!X <Do
False>>
[quoted text, click to view]