Error uploading data into SQL server table

• satish

  Ten Centuries

  Points: 1204

  More actions

  September 15, 2003 at 11:20 am

  #106497

  We are running sql server 7.0 on windows nt. I am trying to import a spreadsheet with data into a table using DTS. The first column of this table is identity. So when i try to insert the spreadsheet into the table it gives me an error stating cannot import null values into destination identity column. How do i overcome the identity column issue using the DTS?

• philcart

  SSC-Forever

  Points: 47796

  More actions

  September 15, 2003 at 5:49 pm

  #474279

  If you don't need to import the ID from the spreadsheet then make sure you exclude that column in the transformations tab.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface