I had a problem when I tried to load some data with XML where SSIS refused to manipulate the blank space. I couldn't use TRIM or REPLACE. I had to...