Datasheet

Chapter 1: SSIS Solution Architecture
3
The problem with Figure 1 - 1 is that this mess didn ’ t happen overnight! It grew into this twisted
unorganized process because of poor planning, coordination, and execution. However, be aware that, a
lot of the time, a corporation ’ s politics may lead to this type of situation. Departments hire their own
technical people and try to go around IT. Systems don ’ t talk to each other nicely. Project pressures (such
as time and budget) cause designers to cut corners.
Following are a few reasons why this kind of tangled mess happens in an organization ’ s data processing,
and examples of the many problems that this “ unorganization ” causes:
Debilitating dependency chains — The biggest problem is that often systems are built on top of
systems on top of systems. The core source data has been connected through so many
precedence links that it takes more time and administrative and development overhead.
Systems at the source and in the middle of dependencies become un - replaceable because of the
amount of effort that switching to a new system would take.
❑
Figure 1-1
c01.indd 3c01.indd 3 9/24/09 11:26:27 AM9/24/09 11:26:27 AM