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?
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on.