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