If you were using a SELECT statement as a data source, you would have to re-build and re-deploy your SSIS, which is a bit of a pain
Thanks for the explaination! I've never used SSIS for ETL so I didn't know but I'll try to keep in mind there are these gotchas if I ever do.