Importing text file

• krypto69

  SSChampion

  Points: 13604

  More actions

  September 29, 2009 at 10:07 am

  #142259

  I'm importing a txt file using the import wizard.

  Everything seems fine but when I run it, I get an error on my first date field

  "0x80004005 Description: "Invalid character value for cast specification".

  (SQL Server Import and Export Wizard)"

  Error 0xc020901c: Data Flow Task: There was an error with input column "FLOOD_LOMA_DETERMINATION_DATE" (2681) on input "Destination Input" (1559). The column status returned was: "The value could not be converted because of a potential loss of data.".

  (SQL Server Import and Export Wizard)

  The date format from my txt file is '20090603' (YYYYMMDD)

  Guessing I need to format my date fields somehow?

• kbatta

  SSCrazy

  Points: 2274

  More actions

  September 29, 2009 at 5:12 pm

  #1059771

  Try converting your dates to MM/DD/CCYY.