Home Forums Data Warehousing Integration Services XML Source Adapter converts empty string into NULL RE: XML Source Adapter converts empty string into NULL

  • September 11, 2013 at 1:50 pm

    #1649483

    azdeji (9/11/2013)

    Below is the sample XML code which produces empty strings but to ssis they are null values -

    <from></from>

    And I try adding default values but they still showed up as null.

    I can't really make big changes to XSD files so hoping ssis will be the solution.

    Thanks

    That didn't render well. Is it like this?

    <from></from>

    If so, I would say that that is a perfect representation of a NULL.

    I would say that an empty string should be represented like this:

    <from>""</from>

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.