Hi,

I have a DTS package which is used to move data between two SQL Server 2000
databases. My destination table has an identity column. I have a few Lookups
defined in the data pump task. My data pump task has three transformations
defined, one of which is a copy column and two are ActivX Script
transformation.

I have not used the Identity column in any of the transformation as I intend
it to be autogenerated.

The problem is that while i execute the datapump task, it fails saying
Integrity violation; attempt to insert NULL data or data that violates
constraints.

I ran a SQL Profiler trace and found that the dataPump task is trying to
insert a NULL into my identity column. Why is this hapenning even though I
have not used that particular column in my transformation.

Not only this, the task tries to insert NULLs in any column that is not used
in any of the transformation.

Thanks in advance for any help.

You could probably benefit from 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


"Vikram Kamath" <VikramKamath (AT) discussions (DOT) microsoft.com> wrote

Do you have the AutoIncrement set to yes on you identity column?

Rick

"Vikram Kamath" <VikramKamath (AT) discussions (DOT) microsoft.com> wrote