asked on

SQL server to Oracle - DTS error

I run a package and it continually fails...

I get this error from job history in Enterprise Manager
Executed as user: INDIANA\LogShippingUserSCC. ...Step_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147217873 (80040E2F) Error string: Error at Destination for Row number 162. Errors encountered so far in this task: 1. Error source: DTS Data Pump Help file: Help context: 0 Error Detail Records: Error: -2147217873 (80040E2F); Provider Error: 1 (1) Error string: [Microsoft][ODBC driver for Oracle][Oracle]ORA-00001: unique constraint (BOS_ADMINIS.PK_AMS_ATPM_MOVEMENT) violated Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147213206 (8004206A) Error string: The number of failing rows exceeds the maximum specified. Error source: Microsoft Data Transformation Services (DTS) Data Pump Help file: sqldts80.hlp Help context: 0 Error Detail Records: Error: -... Process Exit Code 1. The step failed.

slightwv (䄆 Netminder)

You are trying to insert a row that violates a unique constraint. In this case the PK of the table (BOS_ADMINIS.PK_AMS_ATPM_MOVEMENT).

GlobaLevel

ASKER

how would I fix that..

slightwv (䄆 Netminder)

Don't insert duplicate primary key values.

I'm not a DTS person so I'm not exactly sure how to limit the data load with that tool but if you write SQL to do it: You would need to put some sort of a where clause in the select to not copy over the rows already loaded.

GlobaLevel

ASKER

okay cause I need to write a statement that will go out and check and correctly add the right values...

ASKER CERTIFIED SOLUTION

slightwv (䄆 Netminder)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial