Table Schema Change, Column Mapping Problem

Oct 19, 2012 at 11:51 AM

Hello everyone,

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.