Import csv file error into decimal data type

• lallen-661487

  Mr or Mrs. 500

  Points: 531

  More actions

  October 31, 2008 at 9:30 am

  #383279

  I am using the import task wizard to import data into a decimal data type. If there is no data (no value and commas butt against each other), the file will not import. The field in the table allows null values.

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  October 31, 2008 at 9:42 am

  #892422

  It sounds like that SSIS is trying to put an empty string into the field which will not work.

  You may have to use a function on this field that converts empty strings into nulls.