Home Forums Data Warehousing Integration Services Embedded double quotes data from flat file import failing to SQL Server RE: Embedded double quotes data from flat file import failing to SQL Server
Erwin V
SSC Enthusiast
Points: 192
More actions
November 20, 2015 at 5:35 am
#1841321
There are different options to solve this problem.
The easiest would be to change the text qualifier to None in your flat file Connection Manager and use a derived column or a script to strip off leading and trailing double quotes.