Whats wrong with BCP syntax ? 
Author Message
 Whats wrong with BCP syntax ?

Y W,

   bcp database..table in c:\test\test.txt /c

You might check for the other "flags" that may be used in "Books Online" or
other help on BCP.



Mon, 22 May 2000 03:00:00 GMT
 Whats wrong with BCP syntax ?

I am trying to import a text file by using the following command :-

bcp employee in c:\test\test.txt /c

However it reports :-

Msg 156, Level 15, State 1
Incorrect syntax near the Keyword 'in'.

What is the correct syntax ?

Y W Wong



Mon, 22 May 2000 03:00:00 GMT
 Whats wrong with BCP syntax ?

Y W Wong,

I can not replicat your problem here.  I presume you have typed in an
example of the command you used rather than the actual command as the first
message you would have received would have been the prompt for a password.

Please can you post up the exact example, the table structure and some
sample data and I will have another go

Steve Robinson



Mon, 22 May 2000 03:00:00 GMT
 Whats wrong with BCP syntax ?

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

Quote:

> Y W,

>    bcp database..table in c:\test\test.txt /c

> You might check for the other "flags" that may be used in "Books Online" or
> other help on BCP.



Tue, 23 May 2000 03:00:00 GMT
 Whats wrong with BCP syntax ?

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

Quote:

> Y W,

>    bcp database..table in c:\test\test.txt /c

> You might check for the other "flags" that may be used in "Books Online" or
> other help on BCP.



Tue, 23 May 2000 03:00:00 GMT
 Whats wrong with BCP syntax ?

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

Quote:

> Y W,

>    bcp database..table in c:\test\test.txt /c

> You might check for the other "flags" that may be used in "Books Online" or
> other help on BCP.



Tue, 23 May 2000 03:00:00 GMT
 Whats wrong with BCP syntax ?

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

Quote:

> Y W,

>    bcp database..table in c:\test\test.txt /c

> You might check for the other "flags" that may be used in "Books Online" or
> other help on BCP.



Tue, 23 May 2000 03:00:00 GMT
 Whats wrong with BCP syntax ?

Now it reply :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any more idea ?

Y W Wong

Quote:

> Y W,

>    bcp database..table in c:\test\test.txt /c

> You might check for the other "flags" that may be used in "Books Online" or
> other help on BCP.



Tue, 23 May 2000 03:00:00 GMT
 Whats wrong with BCP syntax ?

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

Quote:

> Y W,

>    bcp database..table in c:\test\test.txt /c

> You might check for the other "flags" that may be used in "Books Online" or
> other help on BCP.



Tue, 23 May 2000 03:00:00 GMT
 Whats wrong with BCP syntax ?

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

Quote:

> Y W,

>    bcp database..table in c:\test\test.txt /c

> You might check for the other "flags" that may be used in "Books Online" or
> other help on BCP.



Tue, 23 May 2000 03:00:00 GMT
 Whats wrong with BCP syntax ?

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

Quote:

> Y W,

>    bcp database..table in c:\test\test.txt /c

> You might check for the other "flags" that may be used in "Books Online" or
> other help on BCP.



Tue, 23 May 2000 03:00:00 GMT
 Whats wrong with BCP syntax ?

This time the error message is :-

Msg 170, Level 15, State 1
Incorrect syntax near '.'.

Any idea ?

Y W Wong

Quote:

> Y W,

>    bcp database..table in c:\test\test.txt /c

> You might check for the other "flags" that may be used in "Books Online" or
> other help on BCP.



Tue, 23 May 2000 03:00:00 GMT
 Whats wrong with BCP syntax ?

Hi

Check out the BCP help by typing "BCP /?" at the command prompt.

The dbtable is database.owner.table.  Also check out the /S switch
(server) if you are executing this command from a machine other than
the SQL Server host.

ie::

bcp MyDatabase.dbo.Postal_Codes in e:\datafile\dlpost /c /t ~ /m 500
/U xx /P ***** /S Server

Al
-------------------------------------------



Quote:
>I am trying to import a text file by using the following command :-

>bcp employee in c:\test\test.txt /c

>However it reports :-

>Msg 156, Level 15, State 1
>Incorrect syntax near the Keyword 'in'.

>What is the correct syntax ?

>Y W Wong



Tue, 23 May 2000 03:00:00 GMT
 Whats wrong with BCP syntax ?

You are trying to run bcp from a SQL Query window. BCP is not a SQL
Command, it must be run from an operating system (DOS) command prompt.
--
Kalen Delaney
MCSE, SQL Server MCT, MVP



Quote:
> I am trying to import a text file by using the following command :-

> bcp employee in c:\test\test.txt /c

> However it reports :-

> Msg 156, Level 15, State 1
> Incorrect syntax near the Keyword 'in'.

> What is the correct syntax ?

> Y W Wong



Wed, 24 May 2000 03:00:00 GMT
 Whats wrong with BCP syntax ?

You are trying to run bcp from a SQL Query window. BCP is not a SQL
Command, it must be run from an operating system (DOS) command prompt.
--
Kalen Delaney
MCSE, SQL Server MCT, MVP



Quote:
> I am trying to import a text file by using the following command :-

> bcp employee in c:\test\test.txt /c

> However it reports :-

> Msg 156, Level 15, State 1
> Incorrect syntax near the Keyword 'in'.

> What is the correct syntax ?

> Y W Wong



Wed, 24 May 2000 03:00:00 GMT
 
 [ 15 post ] 

 Relevant Pages 

1. Whats wrong with the syntax ?

2. Whats wrong with this stored procedure?

3. Whats wrong with this query?

4. Whats Wrong?

5. whats wrong

6. whats wrong with this stored procedure

7. Whats wrong with this query?

8. whats wrong with this SQL?

9. whats wrong with the T-SQL Statment

10. whats wrong with this function?

11. Whats wrong here??

12. Whats wrong with this procedure?


 
Powered by phpBB® Forum Software