Automatic ETL between similar tables
This kind of situation is exactly what BIML (Business Intelligence Markup Language) is made for.

From Introduction to Business Intelligence Markup Language (BIML) for SSIS, this solves exactly the problem you are facing:


  With Microsoft SQL Server Integration Services (SSIS), you can build
  powerful and flexible packages to manage your enterprise-wide ETL
  solutions. However, every ETL project has some repetitive tasks: you
  need to import 20 different flat file exports from the ERP system, you
  need to load 15 dimensions into the data warehouse and so on. With
  SSIS out-of-the-box, you are forced to create multiple individual
  packages which is very time consuming due to the lack of easy code
  reuse. In a typical BI project, the ETL implementation can easily take
  up 60% of the project time, so it is beneficial if the development
  time of similar SSIS packages can be cut down.


Some tools you should definitely check out are:


BIDS Helper which has an add-in for BI Development studio or SQL Server Data Tools
SSIS Package generator


If you want to create a metadata mapping table and use that to generate SSIS packages you can have a look at Generate multiple SSIS packages using BIML and metadata