SSIS: Error: An explicit value for the identity column..

Error:

"An explicit value for the identity column in table 'table1' can only be specified when a column list is used and IDENTITY_INSERT is ON.".

Solution and Explanation:

This error occurs when one tries to insert data into a column in which identity insert is on, in such case, we don’t need to insert data in such columns. For this ,Check the number of columns in the source and destination table(excluding one column for which identity insert is on). because it is possible , that you are mistakenly inserting data into destination column (for which identity insert is on).

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.

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.