Proprietà ScriptTask.ScriptLanguage

Articolo
04/26/2013

Gets or sets the programming language in which the script is written.

Spazio dei nomi Microsoft.SqlServer.Dts.Tasks.ScriptTask
Assembly: Microsoft.SqlServer.ScriptTask (in Microsoft.SqlServer.ScriptTask.dll)

Sintassi

'Dichiarazione
Public Property ScriptLanguage As String 
    Get 
    Set
'Utilizzo
Dim instance As ScriptTask 
Dim value As String 

value = instance.ScriptLanguage

instance.ScriptLanguage = value

public string ScriptLanguage { get; set; }

public:
property String^ ScriptLanguage {
    String^ get ();
    void set (String^ value);
}

member ScriptLanguage : string with get, set

function get ScriptLanguage () : String 
function set ScriptLanguage (value : String)

Valore proprietà

Tipo: System.String
The programming language in which the script is written.

Osservazioni

The Microsoft Visual Studio Tools for Applications (VSTA) development environment used by the Script task supports the Visual Basic 2005 and Visual C# programming languages.

Esempi

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 ScriptLanguage property.

using System;
using Microsoft.SqlServer.Dts.Runtime;

namespace ScriptTaskCS
{
  class Program
  {
    static void Main(string[] args)
    {
      Package pkg = new Package();
      string newLine = System.Environment.NewLine;

      Executable exe = pkg.Executables.Add("STOCK:ScriptTask");
      TaskHost thTask = (TaskHost)exe;

      string taskInfo;
      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();
    }
  }
}

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

Vedere anche

Riferimento

ScriptTask Classe

Spazio dei nomi Microsoft.SqlServer.Dts.Tasks.ScriptTask

Condividi tramite