i start to learn the SSIS by company project, and meeting 2 problem for ETL.
1. i have two databases in different ms server and there are some tables in them.
I need to automatically update the schema of tables of destination server while the
number of column of table of source server increase.
2. assume that 1 is OK. When the destination shema of table synchronize with source
table's, the SSIS package must extract, transfer, load more columns than before. How I
let SSIS package know that automatically?
Any help will be appreciated, thank you a lot.