Received an invalid column length from the bcp client for colid 6

I have randomly receiving error while bulk upload data into SQL with message as 'Received an invalid column length from the bcp client for colid 8'.

The error means i am inserting a value into column whose size is more than what is specified in table.

But the thing is like it failed for very first run, some time twice and then it succeeded finally automatically without changing the data.

To give background on this, we received CSV file regularly which is picked by .NET application and using SQLBulkCopy we are inserted it into table.And randomly we receive error like 'Received an invalid column length from the bcp client for colid 8'.But in next run data inserted successfully without any change in data.

Need help.

If this is data issue then, it should fail in every run.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rijwan Ansari5y ago
One of the data columns in the excel (Column Id 6) has one or more cell data that exceed the datacolumn datatype length in the database.
To avoid this, try exceeding the data-length of the string datatype in the database table.
To know exact row, you can add log in txt file. Additionally, use trim(),sometimes this can solve the issue with white space.