SSIS - Control Flow (Workflow)

Ssis2

About

Control flow packages implements workflow logic.

Task

Each control flow task has its own implicit container.

Data Flow Tasks
Data Flow Encapsulates a data flow that transfers data from a source to a destination.
Database Tasks
Data Profiling Generates statistical reports based on a data source.
Bulk Insert Inserts data into a data destination in a bulk load operation.
Execute SQL Runs a structured query language (SQL) query in a database.
Execute T-SQL Runs a Transact-SQL query in a Microsoft® SQL Server® database.
CDC Control Performs a change data capture (CDC) status management operation. 
File and Internet Tasks
File System Performs file system operations, such as creating folders or deleting files.
FTP Performs file transfer protocol (FTP) operations, such as copying files.
XML Performs XML processing operations, such as applying a style sheet.
Web Service Calls a method on a specific web service.
Send Mail Sends an email message.
Process Execution Tasks
Execute Package Runs a specified SSIS package.
Execute Process Runs a specified program.
WMI Tasks
WMI Data Reader Runs a Windows Management Instrumentation (WMI) query.
WMI Event Watcher Monitors a specific WMI event.
Custom Logic Tasks
Script A Microsoft Visual Studio® Tools for Applications (VSTA) script.
Custom Task A custom task implemented as a .NET assembly.
Database Transfer Tasks
Transfer Database Transfers a database from one SQL Server instance to another.
Transfer Error Messages Transfers custom error messages from one SQL Server instance to another.
Transfer Jobs Transfers SQL Agent jobs from one SQL Server instance to another.
Transfer Logins Transfers logins from one SQL Server instance to another.
Transfer Master StoredProcedures Transfers stored procedures in the master database from one SQL Server instance to another.
Transfer SQL Server Objects Transfers database objects such as tables and views from one SQL Server instance to another.
Analysis Services Tasks
Analysis Services Execute DDL Runs a data definition language (DDL) statement in an Analysis Services instance – for example to create a cube.
Analysis Services Processing Processes an Analysis Services object, such as a cube or data mining model.
Data Mining Query Runs a prediction query using a data mining model.
SQL Server Maintenance Tasks
Backup Database Backs up a SQL Server database.
Check Database Integrity Checks the integrity of a SQL Server database.
History Cleanup Deletes out of date history data for SQL Server maintenance operations.
Maintenance Cleanup Deletes files left by maintenance operations.
Notify Operator Sends a notification by email message, pager message, or network alert to a SQL Agent operator.
Rebuild Index Rebuilds a specified index on a SQL Server table or view.
Reorganize Index Reorganizes a specified index on a SQL Server table or view.
Shrink Database Reduces the size of the specified SQL Server database.
Update Statistics Updates value distribution statistics for tables and views in a SQL Server database.

Flow Control

The sequence of task is defined by connecting tasks. The flow of execution is determined with the help of:

  • precedence constraints
  • and logical operations

Ssis Control Flow Constraint Operation

Precedence Constraint

Type The execution flow to be followed when shown as
Success A task completes successfully Green arrows
Failure A task fails red arrows
Completion A task completes (succeeds or fails) blue arrows

Logical Operation

By default, when multiple precedence constraints are connected to a single task, a logical AND operation is applied to the precedence condition, meaning that all of the precedence constraints must evaluate to True in order to execute the connected task. Double click it to change it in a OR operation.

Logical Operation Shown as
AND (Default) solid arrows
OR dotted arrows





Discover More
Ssis2
SQL Server - Integration Services (SSIS)

It is a platform for ETL operation (Developed by MicroSoft). SSIS is (a feature of|included with) SQL Server (introduced in 2005 is the new DTS (Data Transaction Services) platform). SSIS consists...
Ssis Container
SSIS - Container

In SSIS control flow, containers: group related tasks together or define iterative processes. As you can nest containers within other containers, it permits to create a hierarchy of task. Containers...
Ssis Data Profiling Task
SSIS - Data Profiling

Data profiling capabilities The Data Profiling task gathers the requested profile statistics and writes them to an XML document. This can be: saved as a file for later analysis, or written...
Ssis Expression Precedence Constraint
SSIS - Expression

Expressions can include variables and parameters, enabling to set values dynamically based on specific run time conditions for numerous elements, including: Properties Conditional Split transformation...
Ssis2
SSIS - Package

A package defines a workflow of tasks to be executed An unit of task flow execution An unit of deployment (package deployment model) You can execute each package independently, and you can also use...



Share this page:
Follow us:
Task Runner