Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databaseswhen 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
Post Follow-up to this messageDTSRUN 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
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread