ScriptProjectName Property

ScriptTask.ScriptProjectName Property

 

Gets or sets the name of the script project.

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

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

Property Value

Type: System.String

The name of the script project.

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

Return to top
Show:
© 2016 Microsoft