ScriptTask Class
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.
네임스페이스: Microsoft.SqlServer.Dts.Tasks.ScriptTask
어셈블리: Microsoft.SqlServer.ScriptTask (in microsoft.sqlserver.scripttask.dll)
구문
‘선언
<GuidAttribute("2EC4E475-058D-3590-8909-279F833D8B9C")> _
<ComVisibleAttribute(True)> _
Public Class ScriptTask
Inherits Task
Implements IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist
[GuidAttribute("2EC4E475-058D-3590-8909-279F833D8B9C")]
[ComVisibleAttribute(true)]
public class ScriptTask : Task, IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist
[GuidAttribute(L"2EC4E475-058D-3590-8909-279F833D8B9C")]
[ComVisibleAttribute(true)]
public ref class ScriptTask : public Task, IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist
/** @attribute GuidAttribute("2EC4E475-058D-3590-8909-279F833D8B9C") */
/** @attribute ComVisibleAttribute(true) */
public class ScriptTask extends Task implements IDTSBreakpointSite, IDTSSuspend,
IDTSComponentPersist
GuidAttribute("2EC4E475-058D-3590-8909-279F833D8B9C")
ComVisibleAttribute(true)
public class ScriptTask extends Task implements IDTSBreakpointSite, IDTSSuspend,
IDTSComponentPersist
주의
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 Coding and Debugging the Script Task.
Inheritance Hierarchy
System.Object
Microsoft.SqlServer.Dts.Runtime.DtsObject
Microsoft.SqlServer.Dts.Runtime.Task
Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptTask
예
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 =
"Project name: " +
thTask.Properties["VsaProjectName"].GetValue(thTask) + newLine +
"Entry point: " +
thTask.Properties["EntryPoint"].GetValue(thTask) + newLine +
"Script Language: " +
thTask.Properties["ScriptLanguage"].GetValue(thTask) + newLine +
"Precompiled?: " +
thTask.Properties["PreCompile"].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 = "Project name: " & _
thTask.Properties("VsaProjectName").GetValue(thTask) & newLine & _
"Entry point: " & _
thTask.Properties("EntryPoint").GetValue(thTask) & newLine & _
"Script Language: " & _
thTask.Properties("ScriptLanguage").GetValue(thTask) & newLine & _
"Precompiled?: " & _
thTask.Properties("PreCompile").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
스레드 보안
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
플랫폼
개발 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
대상 플랫폼
지원되는 플랫폼 목록은 SQL Server 2005 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
참고 항목
참조
ScriptTask Members
Microsoft.SqlServer.Dts.Tasks.ScriptTask Namespace