I have three servers with identical database. So, I need to copy few tables (common from all server's databases) and store in one database only.
So, I shall follow below steps:
1. CREATE SSIS Package
2. CREATE Four database connections (for different server)
3. Data Flow Task for each database connection
4. Mapping of tables in Data Flow Task.
Is the correct and best approach OR do you have other alternatives?