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