September 28, 2011 at 1:55 pm
Hello,
I am trying to extract data from an operational Informix system through SSIS and writing to SQL Server 2008 R2, using OLE DB drivers. Quite often, the load fails with "An OLE DB record is available. Source: "Ifxoledbc" Hresult: 0x80004005 Description: "EIX000: (-107) ISAM error: record is locked.".
I don't know how the record is locked but I don't really care - I'd like just to skip it so that I can read everything else.
I've setup the Data Flow and set the IsolationLevel to ReadCommited (does that do anything at all for Informix anyway?) and I've set a Execute SQL Task with "set isolation to committed read last committed;" but neither of those seem to help, and I can't get the sql statement in the source of the data flow.
Does anyone have any other suggestions?
I have tried ODBC but run into other issues (string type not passing through).
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply