O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Introduction

There are many components that made SSIS a powerful ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required