Search code examples
viewssispackageoledb

SSIS - what do I look for? "Invalid column type from bcp client for colid 1."

I have an issue with a SSIS package which was working up till now but suddenly starts throwing up an error which I don't know were to place.

I'm uploading bulk records into a OLE DB Destination, inside a view, and I get this error:

An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Invalid column type from bcp client for colid 1.".

What does: Invalid column type from bcp client for colid 1. mean? I've searched high and low for this but still don't understand why it fails now (and it worked before).

I've checked the data that goes to the view and I see no differences in types or lengths.

What do I look for? Have you encountered this? what was the issue?

Solution

  • I've managed to fix this by deleting and then recreating the view where I was inserting the data.

    I'm posting this, maybe someone else could use it and not end up tearing their hairs out.