As I discussed in Chapter 2, SSIS features a much more enterprise-ready architecture than was available through DTS. One feature of this architecture is the abstraction of the different logical layers one might find in any ETL or integration tool. To work as dynamically and with as much flexibility as possible, an ETL tool requires a number of constituent parts to work together in creating a whole. In SSIS, these parts are
  • • Control Flow

  • • Data Flow

  • • Precedence constraints

  • • Connection managers


Control Flow Simple Object Access Protocol XPath Query Connection Manager Package Task 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© James Wightman 2008

Personalised recommendations