I have few questions data BI development
1. What options are available for ensuring consistent configuration of SSIS packages between development, QA, and production run time environments?
2. The source table for a data flow task has been changed so that one of the varchar(50) columns is now a varchar(100). I want to know if this will break the data flow task. what steps would I need to take?
3. When designing a high volume data flow pipeline, Is it good to use a sort task? why or why not? What other options are there if I must have sorted data?