Execute SQL tasks run stored procedures or SQL queries from SSIS packages. A task executes any SQL statements that have been passed to it in sequential order. It provides you with a handy way to ...

Let’s say you have an Execute SQL task and you need to use a large table join to query the source table. There are several ways you can store the queries, and you can even combine some of them.

Utilize the 'Execute SQL Task' block to update the IsDeleted column with a value of 0 in the corresponding tables (Person, OrderHeader, and OrderDetail tables). This update will occur when the records ...

The objective of this homework is to perform an ETL task to extract the data from an OLTP database to a staging database that you have created. Then load the data into a data mart. The data mart is ...

SQL Server 2008 Integration Services ships with the wonderful new Data Profiling Task. Much as the name implies, it profiles the data in a given table and returns a ton of useful information. The task ...