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.