• Article

VariablesCollection.LoadFromString Method

Creates and adds one or more elements, from a delimited string, to the end of the collection.

Namespace:  Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask
Assembly:  Microsoft.SqlServer.Exec80PackageTask (in Microsoft.SqlServer.Exec80PackageTask.dll)

Syntax

'Declaration
Public Shared Function LoadFromString ( _
    str As String _
) As VariablesCollection
'Usage
Dim str As String
Dim returnValue As VariablesCollection

returnValue = VariablesCollection.LoadFromString(str)

public static VariablesCollection LoadFromString(
    string str
)

public:
static VariablesCollection^ LoadFromString(
    String^ str
)

static member LoadFromString : 
        str:string -> VariablesCollection 

public static function LoadFromString(
    str : String
) : VariablesCollection

Parameters

  • str
    Type: System.String
    A delimited string using the following syntax:
    str::= variable;variable;...
    variable::=name,datatype,value
    The name argument contains the name of the PkgVariable to be added.
    The datatype argument contains the data type of the PkgVariable to be added.
    The value argument contains the value of the PkgVariable to be added.
    Any literal comma (,) or semicolon (;) characters included as part of any argument must be prefaced with a backslash (\) character.

Return Value

Type: Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.VariablesCollection
A VariablesCollection
object containing the PkgVariable objects loaded from the string specified in str.