title: Multiple data flow tasks vs one data flow task with many source-destinations
body: <p>I am building a simple SSIS package that truncates 10 tables and fills them up again. The source data is on one Server and the destination is a SQL Server. The data passes through another Server where the SSIS package get executed, since I do not have the permissions to execute SSIS packages from the destination SQL Server.</p>
  <p>Question: should I create 10 separate data flow tasks or one data flow task containing 10 source/destinations?</p>
  <p>My reasoning is that since the data passes though the server which executes the SSIS package then it might use all the memory on that server since all the data are being transformed simultaneously...</p>