ScriptTask 클래스

아티클
04/26/2013

Defines the classes for the Script task, which lets developers write custom code to perform functions that are not available in the built-in tasks provided by Integration Services.

상속 계층

System.Object
  Microsoft.SqlServer.Dts.Runtime.DtsObject
    Microsoft.SqlServer.Dts.Runtime.Task
      Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask

네임스페이스: Microsoft.SqlServer.Dts.Tasks.ScriptTask
어셈블리: Microsoft.SqlServer.ScriptTask(Microsoft.SqlServer.ScriptTask.dll)

구문

‘선언
<GuidAttribute("8D1A24AD-9B5D-49E4-B160-53CD9D6ACCFD")> _
<ComVisibleAttribute(True)> _
Public Class ScriptTask _
    Inherits Task _
    Implements IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist
‘사용 방법
Dim instance As ScriptTask

[GuidAttribute("8D1A24AD-9B5D-49E4-B160-53CD9D6ACCFD")]
[ComVisibleAttribute(true)]
public class ScriptTask : Task, IDTSBreakpointSite, 
    IDTSSuspend, IDTSComponentPersist

[GuidAttribute(L"8D1A24AD-9B5D-49E4-B160-53CD9D6ACCFD")]
[ComVisibleAttribute(true)]
public ref class ScriptTask : public Task, 
    IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist

[<GuidAttribute("8D1A24AD-9B5D-49E4-B160-53CD9D6ACCFD")>]
[<ComVisibleAttribute(true)>]
type ScriptTask =  
    class 
        inherit Task 
        interface IDTSBreakpointSite 
        interface IDTSSuspend 
        interface IDTSComponentPersist 
    end

public class ScriptTask extends Task implements IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist

ScriptTask 유형에서 다음 멤버를 표시합니다.

생성자

	이름	설명
	ScriptTask	Initializes a new instance of the ScriptTask class.

맨 위로 이동

속성

	이름	설명
	BreakpointManager	Gets the BreakpointManager used for controlling breakpoints on this task.
	Breakpoints	Gets an array of breakpoints set on this task.
	DebugMode	Gets or sets a value indicating whether the task is running in debug mode, and whether it should raise the OnBreakpointHit event while the task is running.
	DefaultActiveItem	Gets the default script.
	EntryPoint	Gets or sets the name of the class that is executed as the entry point.
	ExecutionValue	Gets a user-defined object. This field is read-only. (Task.ExecutionValue을(를) 재정의함)
	ProjectTemplatePath	Gets the path of the specified project template.
	ReadOnlyVariables	Gets or sets the comma-delimited list of existing variables made available to the package by the user for read-only access.
	ReadWriteVariables	Gets or sets the comma-delimited list of existing variables made available to the package by the user for read/write access.
	ScriptingEngine	Gets the VSTATaskScriptingEngine class.
	ScriptLanguage	Gets or sets the programming language in which the script is written.
	ScriptLoaded	Gets a value indicating whether the task contains custom script.
	ScriptProjectName	Gets or sets the name of the script project.
	ScriptStorage	Gets the [VSTAScriptProjectStorage] for the script.
	SuspendRequired	Gets or sets a Boolean indicating whether a task should suspend execution when the task encounters a breakpoint. This value is set by the run-time engine for tasks and containers when a breakpoint is encountered.
	Version	* Member deprecated; see Remarks. * Returns the version of the task. This property is read-only. (Task에서 상속됨)

맨 위로 이동

메서드

	이름	설명
	AcceptBreakpointManager	Passes a BreakpointManager to the task. This method is called by the runtime and is not used in code.
	CanUpdate	* Member deprecated; see Remarks. * A Boolean that indicates whether the new package XML can update the old package XML. (Task에서 상속됨)
	Equals	Determines whether two object instances are equal. (DtsObject에서 상속됨)
	Execute	Executes the script contained in this instance of DTS Script Task. (Task.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object)을(를) 재정의함)
	Finalize	Releases all resources used by the ScriptTask. (Object.Finalize()을(를) 재정의함)
	GetConnectionID	Gets a String containing the ID of the connection. (Task에서 상속됨)
	GetConnectionName	Gets a String containing the name of the connection. (Task에서 상속됨)
	GetHashCode	Returns the hash code for this instance. (DtsObject에서 상속됨)
	GetType	(Object에서 상속됨)
	InitializeTask	Initializes the properties associated with the Script task. This method is called by the runtime and is not used in code. (Task.InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker)을(를) 재정의함)
	LoadFromXML	Implements loading of properties from XML document.
	MemberwiseClone	(Object에서 상속됨)
	ReportBreakpointChanges	인프라입니다. Reports the breakpoint changes from the task.
	ResumeExecution	Resumes execution of the task or container by the run-time engine after pausing.
	SaveToXML	Implements saving of properties to XML document.
	SetUniqueScriptProjectName	Sets the unique name of the script project.
	SuspendExecution	Indicates that the executable must suspend execution. This method is called by the run-time engine.
	ToString	(Object에서 상속됨)
	Update	* Member deprecated; see Remarks. * This method updates the old package XML with the new package XML if CanUpdate is set to true. (Task에서 상속됨)
	Validate	Verifies that the component is correctly configured. (Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging)을(를) 재정의함)

맨 위로 이동

주의

The ScriptTask class defines the Script task and handles the interaction of the Script task with the runtime and with Visual Studio for Applications.

For more information, see 스크립트 태스크 and 스크립트 태스크 코딩 및 디버깅.

예

The following code sample, implemented in a console application, adds a ScriptTask to the package and displays the default values of some of its properties.

using System;
using Microsoft.SqlServer.Dts.Runtime;

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

      Console.WriteLine(taskInfo);
      Console.Read();
    }
  }
}

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)

    Console.WriteLine(taskInfo)
    Console.Read()

  End Sub

End Module

스레드 보안

이 유형의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.

참고 항목

참조

Microsoft.SqlServer.Dts.Tasks.ScriptTask 네임스페이스

ScriptTask 클래스

상속 계층

구문

생성자

속성

메서드

주의

예

스레드 보안

참고 항목

참조

추가 리소스