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.