SQL Server Integration Services Concepts
Package :
Package Means collection of tasks.Generally Package contains tasks, variables,connection managers,log providers,precedence constraints,configurations etc.
Control Flow:
Order of tasks execution.
control flow contains containers which provide structures to the package ,tasks which defines functionality of the package.
Data Flow:
Data flow means Extracting data from source systems, performing transformation and loading the data in to the target systems.
Developing a SSIS Package :
Three ways to develop ssis packages
Package :
Package Means collection of tasks.Generally Package contains tasks, variables,connection managers,log providers,precedence constraints,configurations etc.
Control Flow:
Order of tasks execution.
control flow contains containers which provide structures to the package ,tasks which defines functionality of the package.
Data Flow:
Data flow means Extracting data from source systems, performing transformation and loading the data in to the target systems.
Developing a SSIS Package :
Three ways to develop ssis packages
- SSIS Wizard
- SSIS Designer
- Custom Applications
SSIS Wizard :
Wizard allows to develop simple packages to import or export data between one data source to one destination.
Wizard doesn't allows any transformation.
Limitations of SSIS Wizard:
- Wizard only allows to develop a simple package with only one dataflow task.
- That dataflow can have only one source , one transformation and no transformations.
- Wizard doesn't allows to develop a package with pipeline of tasks .
Usage of Wizard:
We can import or export data between one data source to one destination without any transformation.
SSIS Designer:
SSIS designer allows to develop simple and complex packages with workflow of tasks.
To develop a package we have to use
- SSIS Designer
- Tool Box
- properties window
- Solution explorer
The primary sections of ssis designer are
Control Flow:
Order of tasks execution.
control flow contains containers which provide structures to the package ,tasks which defines functionality of the package.
Data Flow:
Data flow means Extracting data from source systems, performing transformation and loading the data in to the target systems.
dataflow pipeline designed with source adapters ,transformations,destination adapters
Event Handlers :
Used to implement error handling ,debugging and monitoring of Packages .
Package Explorer:
Used to browse the elements of the package .
Connection Mangers :
Used to Create and manage the Connections at Package level.
Order of tasks execution.
control flow contains containers which provide structures to the package ,tasks which defines functionality of the package.
Data Flow:
Data flow means Extracting data from source systems, performing transformation and loading the data in to the target systems.
dataflow pipeline designed with source adapters ,transformations,destination adapters
Event Handlers :
Used to implement error handling ,debugging and monitoring of Packages .
Package Explorer:
Used to browse the elements of the package .
Connection Mangers :
Used to Create and manage the Connections at Package level.
