I have a few questions regarding SSIS:
1. Which is considered best practice, a static table definition or a dynamic table definition? We’re talking about a dimension table. My guess is the former seeing as how you need to map columns from source to target tables. Unless, of course, there’s a mechanism that would automatically propagate missing columns?
2. Can SSIS handle TEXT fields, propagating any size data? For replication, there is a configuration on the maximum size of a column to replicate. Are there any concerns for not setting an upper limit?