Re: Skip Rows that Violate Primary Key

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Okay I figured out how to enable the multi-phase datapump, and chekced the
"On Insert Failure", but I don't seem to be able to figure out what to do
beyond that.

I can get it so there's no error, but then no data ends up in the
destination table (although it counts through all the records when you
execute), and I can get it to remain reporting the error and not importing
any rows, but I can't produce the end result I need.

Thanks,
Steve

"Bill Swartz" <wsaharem@xxxxxxxxx> wrote in message
news:uXXhDQLjFHA.1444@xxxxxxxxxxxxxxxxxxxxxxx
> If you enable the multi-phase datapump, you can specify actions to take on
> "On Insert Failure".
>
> You enable the by Right Clicking "Data Transformation Services", then
> properties.
>
> Bill
>
> "- Steve -" <scevans@xxxxxxxxxxx> wrote in message
> news:uy9f4CLjFHA.3300@xxxxxxxxxxxxxxxxxxxxxxx
>> I'm importing data from an Oracle database to my SQL box using DTS.
>>
>> We have a column called GUID. In oracle it's not a primary key, although
>> it's supposed to be (out of my control), in SQL I've made it a primary
>> key.
>>
>> Every now and then we get duplicate GUID's in Oracle. Then my package
>> fails becuase of this one record. How can I keep DTS importing the rest
>> of the rows and skipping the one bad row?
>>
>> Steve
>>
>
>


.

Relevant Pages