Task 클래스
Defines an abstract class that implements the methods and properties common to all tasks in Integration Services.
상속 계층
System. . :: . .Object
Microsoft.SqlServer.Dts.Runtime. . :: . .DtsObject
Microsoft.SqlServer.Dts.Runtime..::..Task
추가 정보...
네임스페이스: Microsoft.SqlServer.Dts.Runtime
어셈블리: Microsoft.SqlServer.ManagedDTS(Microsoft.SqlServer.ManagedDTS.dll)
구문
‘선언
Public MustInherit Class Task _
Inherits DtsObject _
Implements IDTSManagedTask
‘사용 방법
Dim instance As Task
public abstract class Task : DtsObject,
IDTSManagedTask
public ref class Task abstract : public DtsObject,
IDTSManagedTask
[<AbstractClassAttribute>]
type Task =
class
inherit DtsObject
interface IDTSManagedTask
end
public abstract class Task extends DtsObject implements IDTSManagedTask
Task 유형에서 다음 멤버를 표시합니다.
속성
이름 | 설명 | |
---|---|---|
ExecutionValue | Returns a user-defined object. This field is read-only. | |
Version | *** Member deprecated; see Remarks. *** Returns the version of the task. This property is read-only. |
맨 위로 이동
메서드
이름 | 설명 | |
---|---|---|
CanUpdate | *** Member deprecated; see Remarks. *** A Boolean that indicates whether the new package XML can update the old package XML. | |
Equals | Determines whether two object instances are equal. (DtsObject에서 상속됨) | |
Execute | Runs the task. | |
Finalize | (Object에서 상속됨) | |
GetConnectionID | Gets a String containing the ID of the connection. | |
GetConnectionName | Gets a String containing the name of the connection. | |
GetHashCode | Returns the hash code for this instance. (DtsObject에서 상속됨) | |
GetType | (Object에서 상속됨) | |
InitializeTask | Initializes the properties associated with the task. This method is called by the runtime and is not used in code. | |
MemberwiseClone | (Object에서 상속됨) | |
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. | |
Validate | Verifies that the component is properly configured. |
맨 위로 이동
주의
A package consists of one or more tasks. These tasks define units of work that are performed as part of copying and transforming data, communicating with other processes, and performing database management functions.
Inherits from DtsObject and IDTSManagedTask.
예
The following code example is a very simple task implementation for a custom task that inherits from Task.
using System;
using Microsoft.SqlServer.Dts.Runtime;
class MyTask : Task
{
private int m_value = 123;
public override DTExecResult Execute(Connections connections,
Variables variables, IDTSEvents events,
IDTSLogging log, int lastExecResult, DtsTransaction txn)
{
return m_value;
}
}
Imports System
Imports Microsoft.SqlServer.Dts.Runtime
Class MyTask
Inherits Task
Private m_value As Integer = 123
Public Overrides DTExecResult Property connections,() As Execute(Connections
End Property
Variables variables, IDTSEvents events,
IDTSLogging log,int Function txn)() As lastExecResult,DtsTransaction
Return m_value
End Function
End Class
스레드 보안
이 유형의 모든 공용 static(Visual Basic에서는 Shared) 멤버는 스레드로부터 안전합니다. 인스턴스 멤버는 스레드로부터의 안전성이 보장되지 않습니다.
상속 계층
System. . :: . .Object
Microsoft.SqlServer.Dts.Runtime. . :: . .DtsObject
Microsoft.SqlServer.Dts.Runtime..::..Task
Microsoft.DataTransformationServices.Tasks.DTSProcessingTask. . :: . .ASTaskBase
Microsoft.SqlServer.Dts.Tasks.ActiveXScriptTask. . :: . .ActiveXScriptTask
Microsoft.SqlServer.Dts.Tasks.BulkInsertTask. . :: . .BulkInsertTask
Microsoft.SqlServer.Dts.Tasks.DataProfilingTask. . :: . .DataProfilingTask
Microsoft.SqlServer.Dts.Tasks.DMQueryTask. . :: . .DMQueryTask
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask. . :: . .Exec80PackageTask
Microsoft.SqlServer.Dts.Tasks.ExecuteProcess. . :: . .ExecuteProcess
Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask. . :: . .ExecuteSQLTask
Microsoft.SqlServer.Dts.Tasks.FileSystemTask. . :: . .FileSystemTask
Microsoft.SqlServer.Dts.Tasks.FtpTask. . :: . .FtpTask
Microsoft.SqlServer.Dts.Tasks.MessageQueueTask. . :: . .MessageQueueTask
Microsoft.SqlServer.Dts.Tasks.ScriptTask. . :: . .ScriptTask
Microsoft.SqlServer.Dts.Tasks.SendMailTask. . :: . .SendMailTask
Microsoft.SqlServer.Dts.Tasks.TransferDatabaseTask. . :: . .TransferDatabaseTask
Microsoft.SqlServer.Dts.Tasks.TransferErrorMessagesTask. . :: . .TransferErrorMessagesTask
Microsoft.SqlServer.Dts.Tasks.TransferJobsTask. . :: . .TransferJobsTask
Microsoft.SqlServer.Dts.Tasks.TransferLoginsTask. . :: . .TransferLoginsTask
Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObjectsTask. . :: . .TransferSqlServerObjectsTask
Microsoft.SqlServer.Dts.Tasks.TransferStoredProceduresTask. . :: . .TransferStoredProceduresTask
Microsoft.SqlServer.Dts.Tasks.WebServiceTask. . :: . .WebServiceTask
Microsoft.SqlServer.Dts.Tasks.WmiDataReaderTask. . :: . .WmiDataReaderTask
Microsoft.SqlServer.Dts.Tasks.WmiEventWatcherTask. . :: . .WmiEventWatcherTask
Microsoft.SqlServer.Dts.Tasks.XMLTask. . :: . .XMLTask