Re: Changing Child Global Variables Problem

#1

Luis -

Not sure if I understand... Can't you call "Add.." to change the value?

What is your oPackage.ExplicitGlobalVariables set to ?

- Lee

#2

Luis -

I set oPkg.ExplicitGlobalVariables to False.

Oh, yes I see now in my own code I had to Remove and then Add if the
value was already present, otherwise just Add. My mistake.

- Lee

Luis Simões wrote:

Quote:

Well i dont really want to add... i just wanted to change the value of an
existing child global variable...

The explicit is OFF

"Lee Gillie" wrote:

Luis -

Not sure if I understand... Can't you call "Add.." to change the value?

What is your oPackage.ExplicitGlobalVariables set to ?

- Lee

#3

I had reason to iterate the GV's first. I had put the names into a
hashtable, and used the Contains parameterized property.

I notice in some other code I unconditionally do a Remove, protected by
an error trap, and then an Add.

Luis Simões wrote:

Quote:

But can you change the value of an existing global var or not?

How do you remove and detect if a global var exists in a child package?

"Lee Gillie" wrote:

Luis -

I set oPkg.ExplicitGlobalVariables to False.

Oh, yes I see now in my own code I had to Remove and then Add if the
value was already present, otherwise just Add. My mistake.

- Lee

Luis Simões wrote:

Well i dont really want to add... i just wanted to change the value of an
existing child global variable...

The explicit is OFF

"Lee Gillie" wrote:

Luis -

Not sure if I understand... Can't you call "Add.." to change the value?

What is your oPackage.ExplicitGlobalVariables set to ?

- Lee

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Changing Child Global Variables Problem

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: Changing Child Global Variables Problem - 08-27-2004 , 04:38 PM

Re: Changing Child Global Variables Problem - 08-27-2004 , 05:29 PM

Re: Changing Child Global Variables Problem - 08-30-2004 , 03:14 PM