sorry in advance for the newbie question.

i need to insert into a table using a global variable in a "where"
clause. so something like

insert into datasourceA.table1 (field1, field2)
select field1, field2
from datasourceB.table1
where field1 > aGlobalVariable

i can do the part without the where clause using a Transform Data Task,
however i'm not sure how to set the where condition.

thanks,

arthur

add an Execute SQL Task
paste this into the SQL statement box
insert into datasourceA.table1 (field1, field2)
select field1, field2
from datasourceB.table1
where field1 > ?

then click on parameters and select your global variable
you can have multiple parameters the first parameter is the first ? etc etc



"arthur" <alangham (AT) gmail (DOT) com> wrote

ok, got it figured out. solution was very intuitive, however
implementing it was not!