Datasheet

Chapter 1: SSIS Solution Architecture
5
The overly complex control flow shown in Figure 1 - 2 is similar to an overly complex data flow, where
too many components are used, thus making the development, troubleshooting, and support difficult to
manage. The “ Design ” section later in this chapter proposes a better approach for SSIS packages called
the modular package approach .
In summary, both of these types of processes (runaway procedures and unmanageable packages) are
very difficult to support, and not suited to team development, error handling, and scalability (all of
which are addressed in Chapter 12).
Problems with Execution and Troubleshooting
A couple of other issues that often come up in an ETL or data - integration solution are poor process
coordination and difficulty doing root cause analysis. If the “ what happened? ” question can ’ t be
answered quickly and with confidence, then likely there is a problem with the overall solution execution
and logging strategy.
Figure 1-2
c01.indd 5c01.indd 5 9/24/09 11:26:29 AM9/24/09 11:26:29 AM