Integration Services provides various objects to build our SSIS package.Each of these objects has their own characteristics and play an important role in the package building and execution. So let’s understand what they are and what they do.
What is package?
- A package is a collection of control flow elements, data flow elements, connection managers,event handlers, variables and various configurations. We use these objects and assemble them into a single package.
- It’s a unit of work that is retrieved, executed and saved.
following is the quick summary of the objects that builds a package.
| Object | Description |
| Control Flow elements | - Implements workflow in a package.
- Process oriented.
- Interacts with other processes
- Executes in a linear fashion.
|
| Data Flow elements | - Contains sources and destinations.
- Information oriented
- Extracts,Transform and loads the data from various/multiple sources.
|
| Connection Manager | - Connects to the different types of data sources (for e.g. Flat File, Oracle, SQL Server,Excel files, csv files and many other data sources)
- Extracts and loads the data.
|
| Variables | - provides temporary storage during the package execution
- It can be used in expressions to update values dynamically during the transformations.
- Used to update values for the property expressions
- Used to define conditions for the precedence constraints
|
| Event Handlers | - Runs in response to the events raised by the packages, tasks,containers.
|
| Log Providers | - Provides logging mechanism to packages, tasks, containers.
- Can provide/log various important details about the package execution.
|
Happy Learning !!!
No comments:
Post a Comment