bulk copy gives me error

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

hello,
my bcp gives me back a error message
sqlstatement:
BCP Edu.dbo.lam out c:\lam.txt -c-S(SHABAN-PC\SQLEXPRESS2005) Usa Pasdf

the error message is "Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '.'."
hope to get help
thanks

Posted 2-Nov-12 8:45am

sisey shaban

Add a Solution

Comments

ZurdoDev 2-Nov-12 15:23pm

It's a syntax error so if we can't see your syntax we can't help.

OriginalGriff 2-Nov-12 15:25pm

How are you executing it?

sisey shaban 2-Nov-12 17:59pm

how was i suppose to execute it..i wrote those codes in a management studio of sql2005 and i clicked on the execute button, please help if there are other ways of executing..
thank u

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2012-11-04T08:03:00

You can't use bcp commands in MS SQL Managment Studio! This is a command prompt application for MS SQL Server.

Note:
The bcp 9.0 client is installed when you install Microsoft SQL Server tools on your system. If both SQL Server 2005 and SQL Server 2000 tools are installed, depending on the value of the PATH environment variable, you might be using the earlier bcp client instead of the bcp 9.0 client. This environment variable defines the set of directories used by Windows to search for executable files. To discover which version you are using, run the bcp /v command at the Windows Command Prompt. For information about how to set the command path in the PATH environment variable, see Windows Help.
(...)
For information about where to find or how to run the bcp utility and about the command prompt utilities syntax conventions, see Command Prompt Utilities[^].

More about bcp utility here: http://msdn.microsoft.com/en-us/library/ms162802%28v=sql.90%29.aspx[^]

Similar question: http://www.dotnetfunda.com/interview/exam2399-can-we-execute-bcp-command-directly-in-the-sql-server-managemen.aspx[^]