Excel Data load

• Sreejith Sreedharan

  SSCertifiable

  Points: 5403

  More actions

  December 1, 2008 at 7:24 pm

  #198421

  I am trying to load data from Excel. Certain columns can have numeric and alpha numeric data (EG: ORder Number could be "1233" or "ABC-123"). The destination is of varchar data type. When I run the SSIS if the data in the first row for the column is alpha numeric ("ABC-123") the SSIS loads both the alpha numeric and numeric data. But if the first row is numeric then it ignores alpha numeric (loads NULL instead of alpha numeric).

  How can we fix that?

  Thanks

  Sreejith

• Phil Parkin

  SSC Guru

  Points: 246985

  More actions

  December 1, 2008 at 7:35 pm

  #906002

  This is a common complaint with Excel input data. Check out this thread for some further details and ideas:

  http://www.sqlservercentral.com/Forums/Topic423760-148-1.aspx

  Phil

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel