Re: Data Pump Task Failing on identity column
- From: "Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx>
- Date: Mon, 8 Aug 2005 19:30:56 +0100
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:666F8A6B-CE28-4679-87AD-FD22B64D8174@xxxxxxxxxxxxxxxx
> 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.
>
.
- References:
- Data Pump Task Failing on identity column
- From: Vikram Kamath
- Data Pump Task Failing on identity column
- Prev by Date: Re: Data Pump Task Row Count
- Next by Date: Re: Scheduled DTS package fails even when SQLSERVERAGENT logs on as ow
- Previous by thread: Data Pump Task Failing on identity column
- Next by thread: Re: Data Pump Task Failing on identity column
- Index(es):
Relevant Pages
|
