Bandwidth Monitor
SQLDTS.comSQLIS.comSQLIS Wiki
File Inserter Transformation
By Allan Mitchell
Version 2005
Level Intermediate
Page 1 | Page 2 | Page 3 | Page 4 | Page 5 | Page 6 | Page 7

Configuring the ExecuteSQL task

The ExecuteSQL task in SQL Server 2005 has a slightly different look to it but performs all the functions we would expect having come from SQL Server 2000. In this task we are going to need to add an INSERT statement with a parameter followed by a mapping for that parameter to a variable.

Let's start then by dragging from the toolbox the ExecuteSQL task and dropping it inside our ForEachLoop container.

Double click on the task. We should see the dialog that follows

ExecSQL1

As you can see we have entered our statement at the bottom and parmater is denoted by a ?

Now move to the mappings section and let's map the variable we spoke about on the last page to the parameter.

ExecSQL2
Page 1 | Page 2 | Page 3 | Page 4 | Page 5 | Page 6 | Page 7
Related Articles & Links
Read File Transformation