Chapter 2. Control Flow Tasks

by Reza Rad and Pedro Perfeito

In this chapter, we will cover the following topics:

• Executing T-SQL commands: Execute SQL Task

• Handling file and folder operations: File System Task

• Sending and receiving files through FTP: FTP Task

• Executing other packages: Execute Package Task

• Running external applications: Execute Process Task

• Reading data from web methods: Web Service Task

• Transforming, validating, and querying XML: XML Task

• Profiling table statistics: Data Profiling Task

• Batch insertion of data into a database: Bulk Insert Task

• Querying system information: WMI Data Reader Task

• Querying system events: WMI Event Watcher Task

• Transferring SQL server objects: DBMS Tasks