Hi Guys,
I am trying to migrate from DTS to SSIS and 1 of the task was to import data from text file which had double quotes in it. But I will get the below error
"The flat file parser does not support embedding text qualifier in data". I also noticed that the column delimter was not highlighted in the "Columns" tab
After spending hours to resolve this issue, I found the solution and it is to Just click on "Reset Column" in your connection manager and you will get the "Column Delimiter" highlighted,
This solution is not available in most of the google blogs
I am trying to migrate from DTS to SSIS and 1 of the task was to import data from text file which had double quotes in it. But I will get the below error
"The flat file parser does not support embedding text qualifier in data". I also noticed that the column delimter was not highlighted in the "Columns" tab
After spending hours to resolve this issue, I found the solution and it is to Just click on "Reset Column" in your connection manager and you will get the "Column Delimiter" highlighted,
This solution is not available in most of the google blogs
No comments:
Post a Comment