title: When to make multiple packages or data flow task in SSIS?
body: <p>I'm sorry if this a dumb question, as I can't seem to find the answer on google maybe because other people think it's obvious, but I'm a bit a confused beginner. </p>
  
  <p>So, I'm practicing to make a small data warehouse.
  I have the following packages in SSIS:
  1. Copy from operational database to archive database
  2. Copy from archive to staging area
  3. Transformations in staging area and put into data warehouse</p>
  
  <p>These packages are controlled by jobs in SQL Server. </p>
  
  <p>I figured it would be also possible to have only one package and put all 1-2-3 as separate data flow tasks into that package. I started to wonder about this because all task only have one data flow task in it (in the data flow task itself there are many source-destination stuff going on though). </p>
  
  <p>What are best practices for this? When do you make different packages and when multiple data flow tasks. </p>
  
  <p>Thanks in advance. </p>