|
Home > Archive > Microsoft SQL Server forum > November 2005 > About dtsrun
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| when I run the following in sql Analyzer :
dtsrun /S"Local" /Ntestemail /UExternalRO /P"changmail"
got this error:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '/'.
Is the command right?And how to run this dts package in commandline?
Thanks
| |
| Dan Guzman 2005-11-18, 7:23 am |
| DTSRUN is a command-line utility so you execute it from the command-prompt
instead of Query Analyzer. If your requirement is to execute the package on
the SQL Server instead of the client, you can run DTSRUN from a SQL Agent
job CmdExec step. It is also possible to execute command-line utilities
like DTSRUN from Transact-SQL using xp_cmdshell but the SQL Agent job is
generally preferred.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Kevin" <hua@lucent.com> wrote in message
news:dlk0to$kju@netn
ews.net.lucent.com...
when I run the following in sql Analyzer :
dtsrun /S"Local" /Ntestemail /UExternalRO /P"changmail"
got this error:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '/'.
Is the command right?And how to run this dts package in commandline?
Thanks
|
|
|
|
|