I can see why they would embed the selection SQL at demos and presentations - keeps everything in one place & helps things flow more easily.
But in all the places I have worked which use SSIS a lot, using procs as sources has been the de facto standard.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.