How to import a CSV file into SQL which is missing a column name?

• Phil Parkin

  SSC Guru

  Points: 247183

  More actions

  January 10, 2010 at 2:52 am

  #1101478

  Can you confirm that if you fix up the header in the source file, everything runs OK?

  If so, can you post some actual data - just the first couple of rows.

  ---

• SQLFanatic

  SSCommitted

  Points: 1640

  More actions

  January 10, 2010 at 9:45 pm

  #1101610

  Thanks for replying Phil,

  Yes, fixing the header returns success. I have used Script task to modify the file and then import it into SQL which solves the problem.

  Actually, I was looking for a simple solution within SSIS but it looked like using a script is the only way.

  Good Day !

  ________________________________________________________________
  "The greatest ignorance is being proud of your learning"