- obviously, you can use LTRIM / RTRIM in an expression
- you can apply normalize-space ( string ) XPath Query Function
However, if it's necessary to apply this across all the ports, it's possible to use a custom property on a session:
- XMLStripWhitespace=Yes;
And the other way around:
if for some reason the whitespaces are gone but it actually is needed to preserve them, the above mentioned settings need to be reviewed. If there is no trace of a whitespace removal function anywhere, it's possible that it's been set on Integration Service as a default. In such case, for a given session, the whitespaces may be preserved by setting the custom property to the opposite value, overriding the default:
- XMLStripWhitespace=No;
