Export (0) Print
Expand All

ScriptTask.ReadOnlyVariables Property

Gets or sets the comma-delimited list of existing variables made available to the package by the user for read-only access.

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

'Declaration
Public Property ReadOnlyVariables As String
	Get
	Set
'Usage
Dim instance As ScriptTask
Dim value As String

value = instance.ReadOnlyVariables

instance.ReadOnlyVariables = value

Property Value

Type: System.String
The comma-delimited list of existing variables made available to the package by the user for read-only access.

The following code sample, implemented in a console application, adds a ScriptTask to the package and displays the default values of some of its properties, including the ReadOnlyVariables property.

Imports Microsoft.SqlServer.Dts.Runtime

Module Module1

  Sub Main()

    Dim pkg As New Package
    Dim newLine As String = System.Environment.NewLine

    Dim exe As Executable = pkg.Executables.Add("STOCK:ScriptTask")
    Dim thTask As TaskHost = CType(exe, TaskHost)

    Dim taskInfo As String
    taskInfo = 
      
      "Entry point: " & _
      thTask.Properties("EntryPoint").GetValue(thTask) & newLine & _
      "Script Language: " & _
      thTask.Properties("ScriptLanguage").GetValue(thTask) & newLine & _
      
      "ReadOnlyVariables: " & _
      thTask.Properties("ReadOnlyVariables").GetValue(thTask) & newLine & _
      "ReadWriteVariables: " & _
      thTask.Properties("ReadWriteVariables").GetValue(thTask)

    Console.WriteLine(taskInfo)
    Console.Read()

  End Sub

End Module

Community Additions

ADD
Show:
© 2014 Microsoft