Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 BCp Error

Author  Topic 

sanjay5219
Posting Yak Master

240 Posts

Posted - 2014-11-23 : 06:13:59
Hi All,
please suggest what error I am doing here.

bcp.exe TEST..USERLIST out D:\UserList.txt -c -q -C -U sa -P p1234 -t|

It is giving error "The syntax of the command is incorrect."

sunder.bugatha
Yak Posting Veteran

66 Posts

Posted - 2014-11-24 : 07:22:12
Can you remove the spaces for -U and -P and try ? I mean can you try as below :

bcp.exe TEST..USERLIST out D:\UserList.txt -c -q -C -U"sa" -P"p1234" -t|

Hema Sunder
Go to Top of Page
   

- Advertisement -