Error importing data into Identity column

[charlise]

Hello,
I have a DTS package that was set up to import data into a table. Well, the table structure was modified and an identity column was added. Now I get an error when running the package that says that a null value cannot be inserted into that field. I know the identity field is supposed to be populated as data is inserted so of course I shouldn't put a generic value in. Any idea how to correct the package?

 

[mutley1]

Assuming you are using a SQL script (or table copy etc.) as opposed to VB, check out this article.

http://www.sqldts.com/293-5.aspx

HTH,

M.

 

[mutley1]

Sorry - that link starts on page 5 of the article....you might want to go to page1 !!!

Also depends if your source and destination tables have changed or just your destination table. Read the above and it should make sense.