TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
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.
Reply
Answers (
1
)
how to install visual studio 2013 in windows 10 pro?
How to upload and save csv file