Sql-server – Problem with bcp

bcpsql server

I am trying to load my table with some data using bcp. Below is the bcp command that I am using

bcp Job.DBO.FileWatch in ABC.txt -C -t\t -S server\rept -T -f bcp1.fmt

The schema of the FileWatch table is like this. It is just a dummy table

And the ABC.txt file from where I am reading the data is like this

And the format file looks like this.

But when I run my bcp command, it is not throwing any error and at the same time no rows are copied. I read every link on Google's first and second page and tried every switch they mentioned but still it was not working. Any idea why this could be happening?

Best Answer

What is -C (upper case)? That's for the code page.

You should have -C { ACP | OEM | RAW | *code_page* } according to MSDN.

I think you mean -c (lower case), which is for the character data type.

Related Solutions

Sql-server – bcp in of datetime type data results in an “Invalid date / time format”

I have seen this before. Ensure your datetimes are formatted like this:

yyyy-mm-ddThh:mm:ss

Example:

2011-01-18T17:30:59 would represent January 18th 2011 at 5:30:59PM

It has been a while since I ran into an issue similar to this, but I remember this being a step I took to resolve my problem.

Sql-server – SELECT Data Set Using Stored Procedure with BCP Error

You have CR\LF in shell invocation, a no-no. Make it a single line:

DECLARE @SQL VARCHAR(8000); 
SELECT @SQL = 'bcp "EXEC ispsSelectEmptyAsNull ''B1A'';" '+ 
               'queryout "F:\aaData\IPACostData\R15TData\2BSHAEOS_B1A_20121120.txt" '+
               '-f "F:\aaData\IPACostData\R15TData\tmpFormatCard_B1A.fmt" -T -S' + @@SERVERNAME + ''; 
EXEC xp_cmdshell @SQL;
GO

Best Answer

Related Solutions

Sql-server – bcp in of datetime type data results in an “Invalid date / time format”

Sql-server – SELECT Data Set Using Stored Procedure with BCP Error

Related Question