Variables.Add Method

Adds a Variable object to the Variables collection.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

public Variable Add (
	string name,
	bool readOnly,
	string nameSpace,
	Object val
public Variable Add (
	String name, 
	boolean readOnly, 
	String nameSpace, 
	Object val
public function Add (
	name : String, 
	readOnly : boolean, 
	nameSpace : String, 
	val : Object
) : Variable



The name of the package, task, or container variable to add to the collection.


A Boolean that indicates whether the variable is read-only or whether the variable can be modified.


The namespace for the variable. Default value is the User variable namespace. You can also create a namespace to identify variables you create that are used in a certain part of a package. You cannot add variables to the System variable namespace.


The design-time value of the variable.

Return Value

The newly created variable that was added to the Variables collection.

For more information, see Using Variables in Packages.

The following example creates a package, and adds a variable, myVar, to its variable collection.

static void Main(string[] args)
            Package p = new Package();
            //Add a variable, myvar, to the package variables
            // collection. The variable has a value of 5, in the myNamespace
            // namespace.
            Variable var = p.Variables.Add("myVar", false, "myNamespace", 5);
            // Enter the rest of your code here.

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions