"arthur" <alangham@gmail.com> wrote in message
news:1111764210.009363.161230@g14g2000cwa.googlegroups.com...
> 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
>