in reply to How to pull XML out of SSIS so I can study it with XPath
This post suggests that
$dbh->{LongTruncOk} = 1; [download]
"works". Likely, just in the sense of truncating your result. Maybe that XML-SQL has a way to fetch only parts of it?