Sunday, May 5, 2013

SSIS: Error: An OLE DB error has occurred. Error code: 0x80040E21.

Error:

An OLE DB error has occurred. Error code: 0x80040E21.  An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80040E21  Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".  End Error  Error: 2013-02-07 06:05:23.50     Code: 0xC0202025     Source: update table1 OLE DB Command 1 [209154]     Description: Cannot create an OLE DB accessor. Verify that the column metadata is valid.  End Error  Error: 2013-02-07 06:05:23.50     Code: 0xC004701A     Source: Update table1 SSIS.Pipeline     Description: component "OLE DB Command 1" (209154) failed the pre-execute phase and returned error code 0xC0202025.  End Error  DTExec: The package execution returned DTSER_FAILURE (1)


Solution and Explanation :

It’s a metadata issue in the Slowly changing dimension , it occurs due to huge number of columns in the particular table, due to which some times metadata mismatch occurs, the Solution for this is to refresh the SCD. Go through the whole wizard of SCD.

Please provide your feedback for the post, if you find this post useful. Also Post your query or scenario, i will be happy to help.

No comments:

Post a Comment