Hands-On Microsoft SQL Server™ 2005 Integration Services

Execute SQL Task

The Execute SQL task is the main workhorse task to run SQL statements or stored procedures and use the relational power of the underlying database. If you have used DTS, you may have used this task. Typically in DTS, you load data to a staging database and then apply transformations using the Execute SQL task. These transformations vary from generating salutations to Lookup transformations, deriving columns, or applying business rules using SQL Server relational engine. The design philosophy used in SQL Server 2005 Integration Services allow you to perform many of these tasks during the loading phase, thereby increasing performance by reducing repeated inefficient staging of databases. The power of the Execute SQL task is still ...