Monday, March 19, 2012

Meaning of TextQualified attribute in flat file connections

Can anybody explain what the meaning of the TextQualified attribute on a flat file connection is? I am importing delimited flat files where text columns are not qualified by quotes. If I use the Suggest Types button in the Flat File Connection Manager Editor, it sets TextQualified to True for all columns. Importing works fine than, but it also does with TextQualified = False. So what's the difference?

Hans Geurtsen.

If TextQualified=TRUE then a string surrounded by quotes will get interpreted as just the string. In other words the following 2 entries in the file will be loaded as the same:

ThisIsAString
"ThisIsAString"

So it depends on the nature of your data as to whether the TextQualified property has any effect or not.

-Jamie

No comments:

Post a Comment