Post reply

unicode file format, pre processing in general

  • July 15, 2009 at 1:02 am

    #223594

    since we have chosen ssis for most sql interfaces for files and xml im struggling with one annoying problem:

    we receive various unicode, utf-8 file formats. mostly xml files. i cant seem to get ssis to read the files properly to parse them with xml source...

    my next problem is that if i convert the xml files by hand, ssis has problems with files containing special chars such as "é"...

    am i just not understanding unicode in general, or is there a trick out there to handle this problem? i cant seem to find many people with the same problem in google.

    thanks

  • July 15, 2009 at 9:14 am

    #1025147

    Have you tried using the data type conversion in SSIS to convert from unicode to ansi? Is the problem an incorrect conversion? or SSIS not loading the source as it was supposed to?

  • July 17, 2009 at 11:26 am

    #1026347

    Does you XML file have something like this on top:

    <?xml version="1.0" encoding="utf-8"?>

    This is what controls what encoding should be used to read your XML file. Without it, the reader doesn't know how to treat the incoming data.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply