Sunday, May 5, 2013

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


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

1 comment:

  1. Hi,
    i have one scenariou i have one package the package executed 100 records is loaded into destination and committed for 101 record the package is failed if i run the package the package should be start on 101 record on ward should i impliment check point here if it is yes give me example