December 10, 2008 at 7:13 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy