Introduction

SSIS:-        
        SQL Server Integration Services (SSIS) is a component of SQL Server. Using SSIS we can perform ETL (Extraction, Transformation and Loading) operations.

Control Flow:- 

           It’s a workflow engine. It contains Tasks, containers and precedence constrains.

Precedence Constraints:-

          Constraints: Precedence constraint is a link between two Control Flow items. There are three types.

• Success
• Failure
• Completion

 

Data Flow:-

          It contains different Sources (to extract data from source), Transformations (Based on requirement we can modify the source data) and Target (To load data into target database)

Event Handlers:- 

          Based on SSIS package execution different event will fire. For example, package is failed the OnError event will fire. We can create custom event handlers to manage SSIS package at run time.

Connection Manager:- 

          It holds necessary information to connect particular source/target.