I am looking for a SSIS Package to combine ~40 databases and ~96 tables into a single database. The structure of the databases is identical and all tables contain a field that identifies which database it is from. All the databases are on the same sql server. Table 1 dx, id, name, address, ... Table 2 dx, id, description, ... Table 3 dx, id, username, ... *dx is the field that identifies the database The package should be: Easy to setup Easy to maintain Preferably easy to adjust if database schema changes Reliable, logging/alarm if something fails Not too hard to add more tables to copy