Rayis Imayev deals with change:
I will jump straight to the problem statement without a “boring” introduction, which, in a sense, already feels like an opening statement.
Moving data between two or more endpoints is a common task. Sometimes it’s as simple as migrating data from one place to another. Other times, it’s a request to copy specific documents from source environments. In more complex cases, you might need to consolidate multiple data files into the same destination, such as loading several separate files into a single database table.
This was the bete noir of SSIS’s existence. Minor metadata changes would cause the entire system to break down.