none
ssis flatfile connection text qualifier issue RRS feed

  • Question

  • We have a ssis package with flatfile connection single quote ' text qualifier which works well in 2008 R2 version with pipe delimiter,  example:

    c1|c2|c3|
    'John'|'Mc'Donalds'|'New york'
    'Marry'|'Gold'|'New york'

    The same connection manager fail in 2017 SSIS package /after upgrade or if we try to create a new one, the data gets messes up due to that text qualifier in column value. Any tip/trick to resolve this?

    Thanks in advance.


    Mahesh

    Tuesday, June 4, 2019 5:05 PM

All replies