title: upsert in multiple large tables using ssis
body: <p>I have 40 tables having different structure in one of DB on one server  that is  being updated by data provider.</p>
  
  <p>I want to create a SSIS package that would pull data from that data provider DB and insert ,update or delete (merge) data in to development ,Test,UAT and prod DBs.</p>
  
  <p>The tables are having 1m- 3m rows and 20-30 columns each and all the DBs are on SQL Server platform and are on different servers. </p>
  
  <p>The business requirement is to load data everyday on a particular time and  have to use SSIS for this. I am new to SSIS and want your suggestions to create better design. </p>