Partager via

  • Article

ScriptProjectName propriété

Gets or sets the name of the script project.

Espace de noms :  Microsoft.SqlServer.Dts.Tasks.ScriptTask
Assembly :  Microsoft.SqlServer.ScriptTask (dans Microsoft.SqlServer.ScriptTask.dll)

Syntaxe

'Déclaration
<BrowsableAttribute(False)> _
Public Property ScriptProjectName As String
    Get
    Set
'Utilisation
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)

Valeur de la propriété

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

Exemples

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