DUP Primary Key

#1

I work in DTS Package and this DTS insert fileds from TXT file into any
table.
I need control with ON ERROR RESUME NEXT the error "Violation of PRIMARY KEY
constraint. Cannot insert duplicate key in object <table">. Because i can't.
Somebody help me plissss!

Thank's

LML

#2

Hello Luis,

A PK Violation will abort the batch.

I had a small amount of success here.

Multiphase Data Pump (Field Notes)
(http://www.sqldts.com/default.aspx?282)

A much cleaner solution would be to import your file to a staging table and
then use TSQL to compare key values. You can then only insert rows with
key values not already in the destination.

Allan

Quote:

I work in DTS Package and this DTS insert fileds from TXT file into
any
table.
I need control with ON ERROR RESUME NEXT the error "Violation of
PRIMARY KEY
constraint. Cannot insert duplicate key in object <table">. Because i
can't.
Somebody help me plissss!
Thank's

LML

#3

Thanks Allan, you give the solution.
Regards.

LML

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

Quote:

Hello Luis,

A PK Violation will abort the batch.

I had a small amount of success here.

Multiphase Data Pump (Field Notes)
(http://www.sqldts.com/default.aspx?282)

A much cleaner solution would be to import your file to a staging table
and
then use TSQL to compare key values. You can then only insert rows with
key values not already in the destination.

Allan

I work in DTS Package and this DTS insert fileds from TXT file into
any
table.
I need control with ON ERROR RESUME NEXT the error "Violation of
PRIMARY KEY
constraint. Cannot insert duplicate key in object <table">. Because i
can't.
Somebody help me plissss!
Thank's

LML

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DUP Primary Key

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DUP Primary Key - 10-18-2005 , 01:27 PM

Re: DUP Primary Key - 10-18-2005 , 03:21 PM

Re: DUP Primary Key - 10-18-2005 , 03:53 PM