Separating Data Flow from Control Flow
An Integration Services package relies on control flow and data flow as integral parts, though other parts such as event handlers and log providers also support the package. The data flow consists of three major components—data flow sources, data flow transformations, and data flow destinations—which are connected via data flow paths.
One of the key enhancements in SQL Server 2005 Integration Services is the separation of control flow and data flow engines. SSIS predecessor—i.e., SQL Server 2000 Data Transformation Services—had all the control and data flow features available in one engine and hence was difficult to use for creating complex packages to meet stringent data requirements of big enterprises. ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
