Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: SSIS CSV failure to import

    My example failure data

    "aaa",1.00,"AAA"{LF}

    "bbb",1.00,"BBB"{LF}

    "ccc",1.00,"CCC"{LF}

    1. Use HEX Edit (I using UltraEdit) find the line feed {LF} (HEX code is 0A)

    2. Replace HEX 0A to 0D 0A

    Completed.:w00t:

Viewing post 1 (of 1 total)