SQL Server Integration Services: Difference between revisions

Revision as of 09:11, 22 February 2006

Revision as of 00:10, 25 February 2006

Line 13:

'''Tasks'''. A task is an atomic work unit that performs some action. There are a couple of dozen tasks that ship in the box, ranging from the file system task (which can copy or move files) to the data transformation task. The data taransformation task actually copies data; it implements the ETL features of the product.

'''Precedence Constraints'''. Tasks are linked by precedence constraints. The precedence constraint preceedingpreceding a particular task must be met before that task executes. The runtime supports executing tasks in parallel if their precedence constraints so allow. Constraints may otherwise allow different paths of execution depending on the success or failure of other tasks. Together with the tasks, precedence constraints comprise the '''workflow''' of the package.

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