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  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.