SQL Server Integration Services: Difference between revisions

Revision as of 18:28, 26 June 2012

Revision as of 20:33, 6 July 2012

Line 15:

; Event handlers : A workflow can be designed for a number of events in the different scopes where they might occur. In this way, tasks may be executed in response to happenings within the package —such as cleaning up after errors.

; Variables : Tasks may reference variables to store results, make decisions, or affect their configuration.

; Parameters (SQL Server 2012 Integration Services) : Parameters allow you to assign values to properties withint packages at the time of package execution. You can project parameters and package parameters. In general, if you are deploying a package using the package deployment model, you should use configurations instead of parameters.

A package may be saved to a file or to a store with a hierarchical namespace within a SQL Server instance. In either case, the package content is persisted in [[XML]].