Vikas Gupta

Vikas Gupta

  • 936
  • 848
  • 225.4k

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

Jan 28 2021 9:38 AM
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. 
 

Answers (1)