ScriptTask.ScriptProjectName Propriété

  • Référence

Définition

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

Obtient ou définit le nom du projet de script.

public:
 property System::String ^ ScriptProjectName { System::String ^ get(); void set(System::String ^ value); };
[System.ComponentModel.Browsable(false)]
public string ScriptProjectName { get; set; }
[<System.ComponentModel.Browsable(false)>]
member this.ScriptProjectName : string with get, set
Public Property ScriptProjectName As String

Valeur de propriété

String

Nom du projet de script.

Attributs
BrowsableAttribute

Exemples

Implémenté dans une application console, l’exemple de code suivant ajoute un ScriptTask au package. L’application affiche également les valeurs par défaut de certaines des propriétés du ScriptTask, y compris la ScriptProjectName propriété.

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

S’applique à