Freigeben über

  • Artikel

ScriptProjectName-Eigenschaft

Gets or sets the name of the script project.

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

Syntax

'Declaration
<BrowsableAttribute(False)> _
Public Property ScriptProjectName As String
    Get
    Set
'Usage
Dim instance As ScriptTask
Dim value As String

value = instance.ScriptProjectName

instance.ScriptProjectName = value

[BrowsableAttribute(false)]
public string ScriptProjectName { get; set; }

[BrowsableAttribute(false)]
public:
property String^ ScriptProjectName {
    String^ get ();
    void set (String^ value);
}

[<BrowsableAttribute(false)>]
member ScriptProjectName : string with get, set

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

Eigenschaftenwert

Typ: System. . :: . .String
The name of the script project.

Beispiele

Implemented in a console application, the following code sample adds a ScriptTask to the package. The application also displays the default values of some of the properties of the ScriptTask, including the ScriptProjectName 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) & newLine & _

      "ScriptProjectName: " & _
      thTask.Properties("ScriptProjectName").GetValue(thTask)

    Console.WriteLine(taskInfo)
    Console.Read()

  End Sub

End Module

[C#]

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;
using Microsoft.SqlServer.Dts.Tasks;
using Microsoft.SqlServer.Dts.Tasks.VSTAScriptTask;

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) + newLine +
       "ScriptProjectName: " +
        thTask.Properties["ScriptProjectName"].GetValue(thTask);

      Console.WriteLine(taskInfo);
      Console.Read();
      }
   }
}