azdeji (9/11/2013)
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?
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.