Home Forums Data Warehousing Integration Services Specifying Multiple Text Qualifiers For A Flat File ETL RE: Specifying Multiple Text Qualifiers For A Flat File ETL
Phil Parkin
SSC Guru
Points: 247210
More actions
December 11, 2014 at 1:00 am
#1763963
Is there any way around this without doing some crazy file manipulation?
1) Use a delimiter which does not appear in your data.
2) Use SSIS 2012 onwards. See here.