|
|
Posted by Dan Guzman on 11/18/05 13:47
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@netnews.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
Navigation:
[Reply to this message]
|