Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I found the short answer for this,

Is the TextQualifier of the Flat File Connection Manaer is set to ‘’ (double simple quote), and there are open ‘’ without closure in the source file?

If so, this combination leads flat file connection manage to consider everything that appears after ‘’ as just text, without processing the double bars, or even the new line character. So, if there is a large amount of data after the ‘’ sign, the buffer overflows.

In this situation, we can use following methods to avoid this issue:

If the file can be modified, removing the ‘’ combination.
If the file cannot be modified, or it is preferred not to do so, we can change TextQualifier to any other character or even to <none>.

Regards,
J Wick

  • Matas's avatar
    Matas
    Icon for Advocate II rankAdvocate II
    4 years ago

    Hi Anonymous ,

     

    Have you looked at my post or just the title of this topic?

    Since you are writing about "if TextQualifier" is set to something. I have uploaded the pictures of it, it is clearly visible that in my case the TextQualifier is set to <none> and I do not have any "" in my dataset but thank you for the response.

     

    Regards,

    Matas