Post reply

Transformation Task Issue with timestamp column

  • December 5, 2006 at 3:23 pm

    #72204

    Hi Everyone,

    I am having some trouble with Transformation Task.  The column mappings between the source and destination are pretty much the same.  The only difference is the destination has one additional column called "TStamp" (timestamp, not null).

    When I execute the step I recieve the following error:

    Insert error, column 12 ('TStamp', DBTYPE_BYTES), status 10:  Integrity violation; attempt to insert NULL data or data which violates constraints.

    Thanks in advance for your help,

    Jon

  • December 5, 2006 at 5:39 pm

    #676098

    Either you need to remove the constraint on the destination table or change your source query to

    'select *, 'value for not null column' from tablename

     

    MohammedU
    Microsoft SQL Server MVP

  • December 5, 2006 at 5:59 pm

    #676102

    Mohammed,

    Thank you.  It was a contraint violation.  As you suggested above, the task worked after I loaded the tables in the correct order.

    Jon

     

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply