I have a table with 2 columns that I am copying into 3, with the 3rd column
being an identity column, and I have the Enable identity insert checked,
with an "ignore" selected under the transformation columns. But I keep
getting the error that it can't insert data because the ID field cannot be
null. How do I copy a table from one database to another and have it
populate the identity field at the same time?

Have you seen this article?

Problems With IDENTITY() and the DataPump task.
(http://www.sqldts.com/default.aspx?293)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"et" <eagletender2001 (AT) yahoo (DOT) com> wrote

Thanks so much, it hit the nail on the head. I thought I had tried just
about every scenario there was, but this did the trick, so Thanks!

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote