SQLServer 2005 : Active X & Package Variables in Integration Ser

#1

Hi All,

Does anyone know the syntax for accessing package variables in Active X (yes
I could use the new script component but the client wants me to use the
existing method for now).

Have tried the following so far;
Dim vars
Dts.VariableDispenser.LockForRead("Am_I_Master")
Dts.VariableDispenser.GetVariables(vars)

&

'Dts.Variable("Am_I_Master").Value

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

SQLServer 2005 : Active X & Package Variables in Integration Ser

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

SQLServer 2005 : Active X & Package Variables in Integration Ser - 05-05-2006 , 07:22 AM