Import csv file into existing table where 1st row has sep=,

• andrewjmdata

  SSC Enthusiast

  Points: 116

  More actions

  September 23, 2020 at 8:54 pm

  #3790488

  Hi, I have a csv file that has the value "sep=," in the first row and the header in the second row.

  I can import it as using the flat file wizard however that doesn't allow importing into an existing table.

  The data import task allows importing into an existing tables but i can't figure out which options to change so that it ignores 1st row (with "sep=,"), takes header from second row and then data in following columns.

  Any ideas?

  Thanks

   

  Andrew

• Phil Parkin

  SSC Guru

  Points: 247172

  More actions

  September 23, 2020 at 9:06 pm

  #3790492

  I don't use the data import wizard, but if you know how to edit the SSIS package it produces, you will see that there is a property called 'Header rows to skip' on the connection manager for the CSV file. Changing that from 0 to 1 should do it for you.

  ---