Add Method
Collapse the table of content
Expand the table of content

Variables.Add Method (String, Boolean, String, Object)

 

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
)

Parameters

name
Type: System.String

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

readOnly
Type: System.Boolean

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

nameSpace
Type: System.String

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.

val
Type: System.Object

The design-time value of the variable.

Return Value

Type: Microsoft.SqlServer.Dts.Runtime.Variable

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

For more information, see Use 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.
            //
        }
Return to top
Show:
© 2016 Microsoft