Post reply

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

  • 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

  • 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.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

Viewing 2 posts - 1 through 1 (of 1 total)

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