If you have a flat file with quotes around the data as text qualifiers you may have seen the issue where the headers has the quotes even after you put the quote in as the text qualifier. This is a simple issue to resolve. If you check the box “Columns names in the first data row” SSIS sets the first row as the metadata for the column names.
The problem comes when the data has a text qualifier. The text qualifiers end up in the column names.
At this point some people will and check the “Columns names in the first data row” first, and then put in a text qualifier. The problem with that is the text qualifiers end up in the metadata.
To fix this, always enter the text qualifier first then check the box for the column headers.
This will tell SSIS that the text qualifiers are in the first row before it sets that row as the metadata.
About Mike Davis
Mike Davis, is a developer, consultant, trainer, and mentor who is enthusiastic about developing robust application for SQL server. He has expertise in many areas of Business Intelligence including Integration Services, Reporting Services, Database Administration, and .Net Software Development. Mike has created BI and software solutions for financial institutions and pragmatic works. He has developed .Net applications for SQL add-ons as well as standalone applications. Mike also participates as a speaker at events like SQL Server 2008 launch and SQL server user group meetings .
How Big Is Your Package?