Sunday, February 26, 2012

DTSRun error

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.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