I am creating an SSIS package in sql server 2005 which imports a csv file into a database table.
I am using a “Flat File Source” to connect to the csv file. (see sample from csv file)
The problem is that that the file groups an address using “ “ but SSIS sees each comma as a new column. This results in the output displayed below.
Any advice on how to resolve this appreciated. Thanks