I suspect that this is an OLE DB error,
0x80040E05 -2147217915 An object was open
not a SQL error, which is why it works fine in SQL
e.g.OLE DB provider "SQLNCLI" for linked server "xxxx" returned message "Object was open."
I've never experienced it myself but I gather that it usually happens when you run more than one data flow in parallel which have lookups on the same table The error occurs while resynchronizing a row, but at least one row was successfully resynchronized. The error refers to a
storage object that it was trying to open being already open (
because, persumably, both lookups share the same buffer area).