ExpressionTask Class

Reference

Definition

Namespace:: Microsoft.SqlServer.Dts.Tasks.ExpressionTask

Assembly:: Microsoft.SqlServer.ExpressionTask.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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: Object

DtsObject

Task
ExpressionTask

Attributes: DtsTaskAttribute GuidAttribute

Implements: IDTSBreakpointSite IDTSComponentPersist IDTSSuspend

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

共用方式為