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

Question

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

Viewing post 1 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247183 More actions · Answer 1

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.