About
Control flow packages implements workflow logic.
Articles Related
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
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 |