OLE DB error SSIS

  • I am inserting or updating a table depending on whether a new Id is found in csv source file or an existing id is found.

    For new Id a new row is inserted and for an existing Id the corresponding row is updated in the table.

    For insertion I am using "SQL Server Destination" and for updation I am using OLE DB Command.

    For new Id my SSIS package works fine but in case of updating I get an error as:

    An OLE DB error has occurred. Error code:0*80040E14. An OLE DB record is available....

    "Cannot fetch a row from OLE DB provider "BULK" for linked server"(null)"".

    Although I get the above error the package update the row.

    Can anyone suggest what wrong am I doing.

Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply