• 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