I am inserting data from a text file into an SQLserver table.

the text file could have rows which cause a primary key exceptions.

I want to be able to log the row in the file that a primary key exception is
raised.

I need to use "Fast Load" so I cannot use the Data Pump Phase - Insert
Failure.

I have thought about using a staging DB, it is a possibility, but was
wondering if anyone had any ideas on somehow logging the row number that the
exception occurs at.

thanks

Andrew

The problem with a primary key violation is that it will abort the batch
there and then.
I personally would stage the data anyway using a text file and you can
easily then compare in TSQL

--



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


"Andrew" <Andrew (AT) discussions (DOT) microsoft.com> wrote