I am trying to run the following command within my Query Analyzer and get the following:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '/'.
The command is:
DTSRun /S fa314146 /U sa /P admin /N TXTFile_To_SQL
I tried using quotes around my optional parameters but it didn't help.
Thanks for you help.
Igor - isheyman139@.worldsavings.comI found it: xp_cmdshell needs to be used from within Query Analyzer.
Quote:
Originally Posted by isheyman
Hi,
I am trying to run the following command within my Query Analyzer and get the following:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near '/'.
The command is:
DTSRun /S fa314146 /U sa /P admin /N TXTFile_To_SQL
I tried using quotes around my optional parameters but it didn't help.
Thanks for you help.
Igor - isheyman139@.worldsavings.com
I found it: xp_cmdshell needs to be used from within Query Analyzer.|||
Quote:
Originally Posted by isheyman
I found it: xp_cmdshell needs to be used from within Query Analyzer.
Good approach and Reply keep it up.
No comments:
Post a Comment