dts.variables in vb-script task

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » dts.variables in vb-script task

dts.variables in vb-script task

Rate Topic

Display Mode

Topic Options

Author

Message

chrisdiederich

Posted Wednesday, April 09, 2008 8:26 AM

Grasshopper

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

chrisdiederich

Posted Wednesday, April 09, 2008 8:57 AM

Grasshopper

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 »

Permissions