3 global variables 3 sql server connections?

Hello!
I've 3 sql server connections in the DTS package. They are:
conn1
conn2
conn3
Using dynamic properties task, I set up three global variables (gv1, gv2
and gv3).
For conn1 - I am getting server value from @.@.servername. (I am running
this pkg under a sql server job). see the pkg execution code:
declare @.dtsrun varchar(300)
set @.dtsrun = 'dtsrun /F d:\DTS\Mydts.dts /N Mydts /Agv1:8=' +
@.@.servername
exec master.dbo.xp_cmdshell @.dtsrun
for conn2 and conn3, I am using ActiveX script inside the DTS pkg to get
the server values (which are stored in a table in the db).
I am getting server values for 'gv2' and 'gv3'. My question is how would
I pass "gv2" value in "conn2" and "gv3" value in "conn3"?
thanks for your help!
*** Sent via Developersdex http://www.examnotes.net ***why don't have such values into global variables? It seems the most reliable
and safe way
--
Current location: Alicante (ES)
"Test Test" wrote:

> Hello!
> I've 3 sql server connections in the DTS package. They are:
> conn1
> conn2
> conn3
> Using dynamic properties task, I set up three global variables (gv1, gv2
> and gv3).
> For conn1 - I am getting server value from @.@.servername. (I am running
> this pkg under a sql server job). see the pkg execution code:
> declare @.dtsrun varchar(300)
> set @.dtsrun = 'dtsrun /F d:\DTS\Mydts.dts /N Mydts /Agv1:8=' +
> @.@.servername
> exec master.dbo.xp_cmdshell @.dtsrun
> for conn2 and conn3, I am using ActiveX script inside the DTS pkg to get
> the server values (which are stored in a table in the db).
> I am getting server values for 'gv2' and 'gv3'. My question is how would
> I pass "gv2" value in "conn2" and "gv3" value in "conn3"?
> thanks for your help!
>
>
>
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
>