in reply to How to pull XML out of SSIS so I can study it with XPath

This post suggests that

$dbh->{LongTruncOk} = 1;

"works". Likely, just in the sense of truncating your result. Maybe that XML-SQL has a way to fetch only parts of it?