You want to check for reserved characters in the column you want to convert into XML.  The one that jumps out is &  with is used to "escape" other restricted...

While I agree with the "wolves in sheeps clothing" type comments from Jeff, I do want to distinguish between authors and experts.  There are lots of individuals I run across that...

Sorry if this is a stupid question - but I didn't see you mention HOW you were performing the validation in SSIS.  In short you need to actually run an...

If the query needs to have dynamic headers you probably want to acquaint yourself with Jeff Moden's work on cross tabs and pivots.
CrossTabs and Pivots, Part 2

Since you're not providing actual table layouts, this will be an approximation.  That said - the query would look something like:

select [Student ID], AwardYear,[Complete?],CompleteDate,Subloan,Unsub,Pell
from...