Database Reference
In-Depth Information
Execute SQL Tasks
An Execute SQL task allows you to run SQL code on a connected database. For example, to use an Execute SQL
task designed to drop foreign key constraints, you configure it to connect to the proper database by selecting the
appropriate connection manager and then add SQL code to drop the constraints.
Editing Your Execute SQL Task
You add code to an Execute SQL Task Editor window by right-clicking the task and choosing Edit from the pop-up
context menu (Figure 7-29 ).
Figure 7-29. Editing an Execute SQL task
When the editing dialog displays, you will see a number of properties that can be configured; however, the
two you must configure are the Connection and SQL Statement properties.
In SSIS, editing windows are usually divided into pages . These pages are listed on the left side of the dialog.
In an Execute SQL task, configure the connection by first selecting the General page and then clicking the
Connection setting. A dropdown box appears allowing you to select an existing connection manager or even to
create a new one (Figure 7-30 ).
 
Search WWH ::




Custom Search