I'm attempting to run a DTS data transformation task from
a SQL 2000 table to an Oracle Table.
When using the "Test" button under the Transformations
tab it reports a positive test.
But actually running the DTS Package I get an error
(shown at bottom of post).

The error message talks about inserting NULL or data
which violates constraints on a field
called 'INPT_PKT_HDR_ID'.
The problem I have is that this is a primary key field
that Oracle populates.
Now my DTS task doesn't attempt to insert anything into
this field, it leaves Oracle to populate it, so why am I
getting this error????????????


---------------------
@@ErrorRow: 1
Error at Destination for Row number 1. Errors encountered
so far in this task: 1.

Error Source: Microsoft Data Transformation Services
(DTS) Data Pump
Error Description:Insert error, column 1
('INPT_PKT_HDR_ID', DBTYPE_NUMERIC), status 10:
Integrity violation; attempt to insert NULL data or data
which violates constraints.
Error Help File:sqldts80.hlp
Error Help Context ID:30702


Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description:Multiple-step OLE DB operation
generated errors. Check each OLE DB status value, if
available. No work was done.

I'm not sure what you mean about Oracle populating the
primary key. If you mean the column is a sequence, you need
to use Sequence.NextVal.
Oracle doesn't automatically populate those.

-Sue

On Wed, 21 Apr 2004 03:36:54 -0700,
<anonymous (AT) discussions (DOT) microsoft.com> wrote: