Export (0) Print
Expand All

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:
property String^ ScriptProjectName {
	String^ get ();
	void set (String^ value);
}

Property Value

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

Community Additions

ADD
Show:
© 2014 Microsoft