Hi,

I know that a similar question was made yesterday, however
the answer didn't help me.

My question is that if in the Data Transformations Task
Properties, I can use a constant, or a local variable that
is set to a constant, why can't I use the value of a
global variable in the select?

What I actually need is:

I have a ODS table with the following columns:
a, b, c
Then I have a DW table with the columns
company, a, b, c

The DTS I'm using retrieves the company id into the global
variable passed from another aplication.

What I wanted was
insert into ES
select company(GV), a, b, c from ODS.

How can I do this?

Thank You so much to anyone that can help me!!
Ana