You could use the XML source for this, but you would not need to save each row to it's own file. Dump all rows into one XML file and SSIS can read and process them all at once. Much more efficient than doing it one file at a time. And yes, SSIS does this in memory on the SSIS server.