ScriptTask.ScriptProjectName Property

  • Reference

Definition

Namespace:
Microsoft.SqlServer.Dts.Tasks.ScriptTask
Assembly:
Microsoft.SqlServer.ScriptTask.dll

Gets or sets the name of the script project.

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

Property Value

String

The name of the script project.

Attributes
BrowsableAttribute

Examples

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

Applies to