Import XLS to Table Error Attempt to insert null data

• julie taylor

  Mr or Mrs. 500

  Points: 544

  More actions

  June 1, 2005 at 10:55 am

  #60843

  Hi,

  Here is the error I'm getting when I execute the DTS pkg:

  Error at Destination for Row number 861. Errors encountered so far in this task: 1. 

  Error Source: Microsoft Data Transformation Services (DTS) Data Pump

  Error Description:Insert error, column 40 ('AssetHistoryEnabled', DBTYPE_BOOL), status 10:  Integrity violation; attempt to insert NULL data or data which violates constraints.

  Error Help File:sqldts80.hlp

  Error Help Context ID:30702

  Row 861 is the last row of the Excel spreadsheet.  The value in the

  AssetHistoryEnabled column is set to TRUE.  I also get this error for 2 other

  boolean columns which are set to FALSE and TRUE.

  I am wondering if this is an EOF problem, where it is actually trying to read the 862 row which is blank.  Do I need to do something in Excel to tell it that row 861 is the last record of the file?

  Thanks for your help!

   

   

   

• Jonathan Stokes

  SSCrazy Eights

  Points: 9861

  More actions

  June 2, 2005 at 4:19 am

  #562459

  Excel guesses where it think the eof occurs. If any cells have been blanked for example, it may still keep the same pointer.

  The best way to see where excel assumes the spreadsheet ends is to press CTRL + END. This will take you to there.

  ---

  ------------------------------
  The Users are always right - when I'm not wrong!

• julie taylor

  Mr or Mrs. 500

  Points: 544

  More actions

  June 2, 2005 at 6:55 am

  #562494

  Thanks Jonathan for your help.  It completes successfully now.