Ignore Richard and the bastard, this is an appropriate question in the correct forum. Unfortunately your question is a little too broad to elicit a reasonable response. SSIS is such a wide subject. I do know that we moved from ETL to ELT where the transforms are done via stored procedure. It is faster and I find it easier to debug and test. So SSIS just moves the data from the source into staging tables and launches the transform stored proc. Never underestimate the power of human stupidity RAH

That is no excuse.

Good that you have started to write and post. It's a great way to learn as you get feedback, whether it's phrased in a kindly manner or not, there are often little gems that you had not have thought of. I often find that I get half way through a post and realise that I'm totally wrong and discard it. But simply writing the post allowed me to clarify my idea to myself and see why it was wrong.