Post reply

Attempt to insert Null data

  • August 27, 2004 at 4:29 pm

    #60181

    Greetings Database Wizards,

    I am new to DTS and am creating a package that will copy columns from a .csv file into a destination table that has an ID field with the identity constraint.  The import .csv file doesn't have a corresponding value for that field, but it does contain the other needed fields for the table.  I am excluding the ID field in the transformations tab, and when I execute the package, I still get the "Integrity violation; attempt to insert NULL data" error.  The only way I can get the data into the table is by removing the identity constraint and allowing NULL for that column.  Has anyone ran into this problem??

    Many thanks........ 

  • August 27, 2004 at 5:12 pm

    #520965

    There is a checkbox on the data transforms to ignore identity fields. Nothing should be mapped to that field in the map tab.

  • August 30, 2004 at 8:42 am

    #521070

    Thanks for the reply Steve.  The only checkbox that I am seeing (right-click on task and go to properties -- Options tab) somewhat resembling what you're referencing, is the 'Enable Identity Insert' box.  That isn't it, is it???  I double-checked the 'Transformations Data Task Properties' tab (right-click on task and go to properties) and verified that the ID field on the destination doesn't have anything mapped to it.  Is there a piece that I am missing???

    Thanks again for your help.....

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

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