Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2003
    Posts
    46

    Unanswered: IDENTITY Problems Updating ZipCode Table

    I am having problems updating my zip code table that contains zip, city, state, long, lat, ect..

    I have the latest CSV file, I tried to use the import wizard in SQL Server 2000 Enterprise Manager.
    I set the ID field as <ignore> and specified the appropriate columns for the rest of the data matching from CSV to already designed and working zip code table. Also I checked the box that said "Delete Rows in Destination Table" as well as "Enable Identity Insert" was checked

    I ran the wizard, and now I have empty table and it will not insert any records because the error said that the identity column can not accept NULL.

    What do I do? I am not updating the identify column so Is it telling me it can't insert NULL into ID?

    Any suggestions...

    Thanks,
    Lito

  2. #2
    Join Date
    Aug 2004
    Posts
    5
    Quote Originally Posted by lito
    I set the ID field as <ignore>
    ...
    as well as "Enable Identity Insert" was checked
    ...
    error said that the identity column can not accept NULL.
    You are inserting NULL into the ID field, because you have "<ignore>" selected for the ID column, and "Enable Identity Insert" checked. You need to uncheck "Enable Identity Insert" and this should work.

  3. #3
    Join Date
    Nov 2003
    Posts
    46

    Red face Done!

    For the 5th Time I repeated the process and this time i did not check "Enable Identity Insert" and it worked.

    Sory to bother you, I was just getting frustrated with this stupid problem

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    That's Ok... I think the reason that most of us hang out here is to give folks a hand (and occaisionally make the others say "Doh, why didn't I think of that!"). As long as life is good now, that is all that counts!

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •