I am trying to create an import process from csv file to sql db.
I setup a flat file source, I checked column names in the first data row, and text qualifier is double quotes, when I preview it, the data look Ok, they no longer has double quotes around them, but the column heading still have double quotes.
why it is like that? Thanks