Processing NULLs and empty values

XML Input can replace NULLs with empty values, and replace empty values with NULLs. The target columns must use one of the string or binary SQL types.

In an input document, NULLs are missing elements or attributes that are referenced by XPath expressions. Empty values include empty elements (<a></a>) and empty attributes (att="").

For examples using these replacements, see Null and empty value processing.

For information about specifying replacements, see Transformation settings.