Integration Services Tasks
Tasks are control flow elements define units of work. that performed in a package control flow. An SQL Server Integration Services package made up of one or more tasks. If the package contains more than one task. they connected and sequenced in the control flow by precedence constraints.
custom tasks using a programming language. that supports COM, such as Visual Basic, or a.NET programming language, such as C#.
The SSIS Designer, SQL Server Integration Services for working with packages. the design creating package control flow and provides custom editors for configuring tasks. the SQL Server Integration Services object model create packages.
Types of Services Tasks
Integration Services includes the following types of tasks.
Data Flow Task
that runs data to extract data, apply column-level transformations, and load data.
Data Preparation Tasks
These tasks directories, download files run Web methods, apply operations to XML documents.
The tasks processes to run packages, run programs or batch files. send and receive messages between packages, send e-mail messages, read Windows Management Instrumentation. SQL Server Tasks The tasks that access, copy, insert, delete, and change SQL Server objects and data.
The tasks extend package functionality by using scripts.
Analysis Services Tasks
The tasks that create, change, delete, and process Analysis Services objects.
The tasks that perform administrative functions. The backing up and shrinking SQL Server databases and running SQL Server Agent jobs.
The write custom tasks using a programming language. that supports COM, such as Visual Basic, or a.NET programming language, such as C#. If access custom task in the SSIS Designer, create and register a user interface for the task.
Configuration of Tasks
An Integration Services package contain a single task. such as an Execute SQL task deletes records in a database table when the package runs.
packages contain several tasks and context of the package control flow. Event handlers are workflows that run in response to run-time events, can also have tasks.
the task to a package using SSIS Designer, see Add or Delete a Task or a Container in a Control Flow.
Each task configured using the custom dialog boxes SSIS Designer provides. the Properties window included in SQL Server Data Tools. A package can include many tasks of the same type.
Tasks Connections and Groups
If the task contains more than one task. they connected and sequenced in the control flow by precedence constraints.
Tasks grouped together and performed as a single unit of work, or repeated in a loop. For more information, see the Foreach Loop Container, For Loop Container, and Sequence Container.