Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

dts.variables in vb-script task Expand / Collapse
Author
Message
Posted Wednesday, April 09, 2008 8:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 19, 2008 7:17 AM
Points: 12, Visits: 40
Hi!

I've got a package with 1 Dataflow-Task and a script task and a global variable named "test". The scope ist on the package.

In the first dataflow-task i have a oledb connection and e "row count" task. In the adva. editor i set the custom property Variablename to test.

The script task have to look up the variable "test". I tried this with

msgbox dts.variables("test").value

But i get an exception.

Can enyone explain me?

Thanks
Chris
Post #482377
Posted Wednesday, April 09, 2008 8:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 19, 2008 7:17 AM
Points: 12, Visits: 40
ok, got it.

Had to set ReadWriteVariables Property to the variable.
Post #482411
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse