共用方式為


ExpressionTask Class

Definition

public ref class ExpressionTask : Microsoft::SqlServer::Dts::Runtime::Task, Microsoft::SqlServer::Dts::Runtime::IDTSBreakpointSite, Microsoft::SqlServer::Dts::Runtime::IDTSComponentPersist
[Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.expressiontask.F1", IconResource="TaskIcon", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.ExpressionTask.SR), SamplesTag="SsisExpressionTask", TaskContact="Expression Task;Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.ExpressionTask.ExpressionTaskUI, Microsoft.SqlServer.ExpressionTaskUI, Version=13.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")]
[System.Runtime.InteropServices.Guid("35465A03-2269-4FCC-83A8-68B2014650F7")]
public class ExpressionTask : Microsoft.SqlServer.Dts.Runtime.Task, Microsoft.SqlServer.Dts.Runtime.IDTSBreakpointSite, Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist
[Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.expressiontask.F1", IconResource="TaskIcon", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.ExpressionTask.SR), SamplesTag="SsisExpressionTask", TaskContact="Expression Task;Microsoft Corporation; SQL Server 2017; © 2017 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.ExpressionTask.ExpressionTaskUI, Microsoft.SqlServer.ExpressionTaskUI, Version=14.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")]
[System.Runtime.InteropServices.Guid("5BEF28F6-024B-484E-9F1C-8A872D85B009")]
public class ExpressionTask : Microsoft.SqlServer.Dts.Runtime.Task, Microsoft.SqlServer.Dts.Runtime.IDTSBreakpointSite, Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist
[Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.expressiontask.F1", IconResource="TaskIcon", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.ExpressionTask.SR), SamplesTag="SsisExpressionTask", TaskContact="Expression Task;Microsoft Corporation; SQL Server 2019; © 2019 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.ExpressionTask.ExpressionTaskUI, Microsoft.SqlServer.ExpressionTaskUI, Version=15.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")]
[System.Runtime.InteropServices.Guid("D0C70352-CD3D-45E7-A882-8FA0BC2C6506")]
public class ExpressionTask : Microsoft.SqlServer.Dts.Runtime.Task, Microsoft.SqlServer.Dts.Runtime.IDTSBreakpointSite, Microsoft.SqlServer.Dts.Runtime.IDTSComponentPersist
[<Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.expressiontask.F1", IconResource="TaskIcon", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.ExpressionTask.SR), SamplesTag="SsisExpressionTask", TaskContact="Expression Task;Microsoft Corporation; SQL Server 2016; © 2015 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.ExpressionTask.ExpressionTaskUI, Microsoft.SqlServer.ExpressionTaskUI, Version=13.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")>]
[<System.Runtime.InteropServices.Guid("35465A03-2269-4FCC-83A8-68B2014650F7")>]
type ExpressionTask = class
    inherit Task
    interface IDTSBreakpointSite
    interface IDTSSuspend
    interface IDTSComponentPersist
[<Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.expressiontask.F1", IconResource="TaskIcon", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.ExpressionTask.SR), SamplesTag="SsisExpressionTask", TaskContact="Expression Task;Microsoft Corporation; SQL Server 2017; © 2017 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.ExpressionTask.ExpressionTaskUI, Microsoft.SqlServer.ExpressionTaskUI, Version=14.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")>]
[<System.Runtime.InteropServices.Guid("5BEF28F6-024B-484E-9F1C-8A872D85B009")>]
type ExpressionTask = class
    inherit Task
    interface IDTSBreakpointSite
    interface IDTSSuspend
    interface IDTSComponentPersist
[<Microsoft.SqlServer.Dts.Runtime.DtsTask(HelpKeyword="sql13.dts.designer.expressiontask.F1", IconResource="TaskIcon", LocalizationType=typeof(Microsoft.SqlServer.Dts.Tasks.ExpressionTask.SR), SamplesTag="SsisExpressionTask", TaskContact="Expression Task;Microsoft Corporation; SQL Server 2019; © 2019 Microsoft Corporation; All Rights Reserved;http://www.microsoft.com/sql/support/default.asp;1", TaskType="DTS90", UITypeName="Microsoft.SqlServer.Dts.Tasks.ExpressionTask.ExpressionTaskUI, Microsoft.SqlServer.ExpressionTaskUI, Version=15.0.0.0, Culture=Neutral, PublicKeyToken=89845dcd8080cc91")>]
[<System.Runtime.InteropServices.Guid("D0C70352-CD3D-45E7-A882-8FA0BC2C6506")>]
type ExpressionTask = class
    inherit Task
    interface IDTSBreakpointSite
    interface IDTSSuspend
    interface IDTSComponentPersist
Public Class ExpressionTask
Inherits Task
Implements IDTSBreakpointSite, IDTSComponentPersist
Inheritance
ExpressionTask
Attributes
Implements

Constructors

ExpressionTask()

Properties

DebugMode
ExecutionValue

The execution value is assigned the name of the new file

Expression
SuspendRequired
TargetServerVersion (Inherited from Task)
Version

*** Member deprecated; see Remarks. ***   Returns the version of the task. This property is read-only.

(Inherited from Task)

Methods

AcceptBreakpointManager(BreakpointManager)
CanUpdate(String)

*** Member deprecated; see Remarks. ***   A Boolean that indicates whether the new package XML can update the old package XML.

(Inherited from Task)
Equals(Object)

Determines whether two object instances are equal.

(Inherited from DtsObject)
Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object)
GetConnectionID(Connections, String)

Gets a String containing the ID of the connection.

(Inherited from Task)
GetConnectionName(Connections, String)

Gets a String containing the name of the connection.

(Inherited from Task)
GetHashCode()

Returns the hash code for this instance.

(Inherited from DtsObject)
InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker)

Initializes the properties associated with the task. This method is called by the runtime and is not used in code.

(Inherited from Task)
LoadFromXML(XmlElement, IDTSInfoEvents)
ResumeExecution()
SaveToXML(XmlDocument, IDTSInfoEvents)
SuspendExecution()
Update(String)

*** Member deprecated; see Remarks. ***   This method updates the old package XML with the new package XML if CanUpdate(String) is set to true.

(Inherited from Task)
Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging)
ValidateExpression(VariableDispenser)

Applies to