By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,607 Members | 1,806 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,607 IT Pros & Developers. It's quick & easy.

ssis Bulk insert failed "Received an invalid column length from thebcp client...".

P: n/a
I am trying to bulk load a flat file into a SQL server table (2005)
using the integration services. I got the following error:

[OLE DB Destination [190]] Error: An OLE DB error has occurred. Error
code: 0x80004005. An OLE DB record is available. Source: "Microsoft
OLE DB Provider for SQL Server" Hresult: 0x80004005 Description:
"Received an invalid column length from the bcp client for colid

This has happened before also. Once I close the particular SSIS
package and open the same package again, and when I execute again, it
worked fine.

Now, I have 21 million records that needs to be loaded to a table, it
took about 45 minutes to read and during the final commit, I got the
above error message. It might work, if I close and open; I have not
tried. Has anyone come across this error? Please let me know if I
need to change anything.

Thank you,
Mar 11 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.