Hello All,
I have come across this issue with the Flat File Source when the delimiter is set to a comma.
"""KAILUA KONA,HI""","CA",
In the data snippet above and with the setting of using a comma as a column delimiter
and a " as the text qualifer.
the data will be parsed in this fashion:
"""KAILUA as a column:
HI""" as a column
CA as column
when it should be
"KAILUA,HI" as a column
CA as column.
Is there a way to let the Flat File Source to let it know not to parse the data in multiple quotes ?
Thank you
Eric Flores
The flat file parser does not know how to handle embedded qualifiers.
In this case, you can workaround this by loading the qualified data and then stripping the qualifiers in Derived Column or Script transform.
HTH.
|||I will try that out and see if it will work. Though in my data snippet, the comma in question is not even a qualifier but is part of the data.
What I do not get is that in DTS for SQL Server 2000 when specifying a flat file as having comma as the column delimited and a double quote as the text qualifier that when given the data snippet in my previous post that it would parse the data into the correct two columns.
|||
Eric,
feel free to go to the product feedback site below and report your issue. That will create a bug in our system.
http://lab.msdn.microsoft.com/productfeedback/default.aspx
|||This has been "resolved" in product feedback. Was there a resolution or is this just the way it is going to be?
没有评论:
发表评论