Database Reference
In-Depth Information
Figure 7-31.
Configuring a SQL statement for an Execute SQL task
SQL code can be typed into the dialog, but a better way is to create the ETL code beforehand with SQL
Management Studio (as we did in Chapter 6) and then copy and paste the code into the SSIS window. One
advantage to this method is that you can test and correct your code before adding it to your Execute SQL Task.
Once you have selected a connection and added your SQL code, you can close the Execute SQL Task dialog
window and test your work by executing it.
Executing Your Execute SQL Tasks
SSIS packages consist of XML code that describes various tasks. Each task placed on the designer surface is a
collection of programming instructions in an XML format. When you configure a task, you are filling in attributes
and elements of the XML programming code, as shown in Figure
7-32
.
Like any other programming language, the code by itself does not do anything unless software exists that
can read the programming instructions and perform the action accordingly. This type of software is often referred
to as a
runtime environment
or
runtime engine
. Visual Studio includes an SSIS debugging engine that launches
the SSIS runtime environment. After creating your package, you will no longer need Visual Studio to run your
SSIS code, since it can run on any computer that has the SSIS runtime installed on it, even if Visual Studio is not
installed.
