<anonymous@discussions.microsoft.com> wrote:

>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.