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.
LVL 10
GlobaLevelProgrammerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
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).
0
GlobaLevelProgrammerAuthor Commented:
how would I fix that..
0
slightwv (䄆 Netminder) Commented:
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.

0
GlobaLevelProgrammerAuthor Commented:
okay cause I need to write a statement that will go out and check and correctly add the right values...
0
slightwv (䄆 Netminder) Commented:
What is the primary key on the Oracle table?  Hopefully you can add some value to DTS to only process 'new' records.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.