If you can change the stored procedure to output as a concatenated string of the required columns data delimited with "," for the respective customer then you can write to CSV directly by defining flat file connection manager.

If Excel is the required output format then you can acheive this using the derived column transformation.