For the string data type, the XML source adapter converts incoming empty (zero length) strings to NULL. This means there's no way tell if the fields was present with an empty string, or if the field was not present at all (i.e. with no XML elements.)
Is there a way round this problem?
Distinguishing NULL from zero length strings is important since the XSD files will contain more than 30 fields and the XML sent through will only have the fields needed for updating meaning ssis will still bring in all the fields and make them null unless they are in the XML file.
Thanks for any advice.
If you take a look at the contents of the XML file in a text editor, what is the difference between an empty string and a NULL? How is NULL represented in the file?
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.