January 28, 2008 at 11:27 pm
I am trying to simulate an "UPSERT" command using a lookup transformation. Basically I am uploading data from a .csv file into a database table and I am using a lookup transformation in between to check the destination table to see whether the values exist in the table or not. The result should be that if the values exist, the table should be updated, if not then the new records should be appended to the table.
I have configured the lookup to replace the two columns that it is checking on however the package fails and i receive the following error:-
[Dest - HR_Manual_Stg [467]] Error: An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.". An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Reading from DTS buffer timed out.".
I think the error is clear, however, I am not sure how to go about it
Your help is much appreciated.
January 30, 2008 at 8:17 am
Don't think that has anythign to do with the lookup. Can you execute the lookup statement from SQL when connected tot he same DB as the lookup connection?
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
February 9, 2008 at 3:10 pm
Yes you can, i have used the lookup before to check for existing records when updating dimension tables, however, whenever the package is run again, if the record exists the package fails and i don't want that behaviour.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply