Queryout bcp error? Works when using table name.

[gcole]

The following command works if I sub a 'table name' for the query and 'out' for queryout':

execute master..xp_cmdshell "bcp " Select Time1, Time2, Forced From in_tblname" queryout d:\transfer\test.txt -c -q -t,"

I am getting this error:
"Incorrect syntax near ' queryout d:\transfer\test.txt -c -q -t,'.
"

Can anyone spot the problem?

 

[Rosko]

If you receive an error like that in combination with quotes always change your outer double quotes into single quotes.

And you should use your DBNAME.OBJECTOWNER.OBJECTNAME identifier. Otherwise you could have some problems too.

That should do the trick

Hope this helps
GL


Rosko