EricEyster (2/25/2014)

---

WheelsGuy (2/25/2014)

---

EricEyster (2/25/2014)

---

close.

the statement from variable would be used if you have a script task that assembles the full query text. That is not the case here. Use "Direct Input" and paste the select into the SQLStatement block. It should look like

select *

from test

where c1 = ?

next, go to parameter mappings and add a new param, pick you variable and data type.

I'm a bit confused (too much multitasking). In the Execute SQL task, I have Direct input, and the SQLStatement I need to grab the variable data. Would the example SQL you listed be in the OLE DB Source of the Data Flow or somewhere else?

Sorry, multitasking myself.

Your second step: is it an update statement or a data flow? If you are updating or inserting a record on the second system, you can use a ExecuteSQL task. Data flow would be for pulling many records to the second system.