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
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.