Adding Advanced Features to Packages
SQL Server 2005 Integration Services (SSIS) includes many features that you can use to extend the functionality of Integration Services packages. After you have finished building a basic package, you may want to add other features that make the package more robust, flexible, and easier to troubleshoot.
You can add the following features to packages:
- Logging that captures information about a package at run time, making it easier to troubleshoot package performance and failure.
- Transactions that ensure data integrity by supporting commit and rollback when packages perform multiple operations.
- Checkpoints that make it possible to restart a package from a point of failure, instead of rerunning the workflow for the complete package.
- Variables that pass values to scripts, provide parameter values for SQL statements, or modify the evaluation results of expressions.
- Expressions and property expressions that update values in columns and properties of packages and package objects.
- Queries that data flow components, such as the Lookup transformation, use to create in-memory reference tables.
The following table lists topics related to advanced package features.
| Topic | Description |
|---|---|
Describes what log providers are, how to add logs to a package, and how to configure logging options. |
|
Describes how to use transactions in a package to ensure data integrity and manage rollback. |
|
Describes checkpoints, and how to implement checkpoints in a package to make it restartable. |
|
Describes the different ways you can use variables in a package. |
|
Describes the different ways you can use expressions in a package. |
|
Describes property expressions, and how to use them to update the values of properties in a package. |
|
Describes the Query Builder and the different ways you can provide query statements. |
See Also
Other Resources
Designing and Creating Integration Services Packages