SQL Server Integration Services SSIS service Two distinct

Архитектура • SQL Server Integration Services (SSIS) service • Two distinct runtime engines: − Control flow − Data flow • 32 -bit and 64 -bit editions 3

Примеры компонентов SSIS • • Package Connection manager Control Flow Containers

Виды Tasks (примеры) • • Data Flow Task Data Preparation Tasks Process Communication Tasks SQL Server Tasks Analysis Services Tasks Database Maintenance Tasks Scripting Tasks

Примеры компонентов SSIS • Precedence Constraints • Variables • Data Flow

Примеры компонентов Data Flow • Data Flow Sources • Data Flow Destinations • Data Flow Transformations − Rowset Transformations − Split and Join Transformations