ExpressionTask Classe

Referência

Definição

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

Assembly:: Microsoft.SqlServer.ExpressionTask.dll

Importante

Algumas informações se referem a produtos de pré-lançamento que podem ser substancialmente modificados antes do lançamento. A Microsoft não oferece garantias, expressas ou implícitas, das informações aqui fornecidas.

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

Herança: Object

DtsObject

Task
ExpressionTask

Atributos: DtsTaskAttribute GuidAttribute

Implementações: IDTSBreakpointSite IDTSComponentPersist IDTSSuspend

Construtores

ExpressionTask()

Propriedades

DebugMode
ExecutionValue	O valor de execução é atribuído ao nome do novo arquivo
Expression
SuspendRequired
TargetServerVersion	(Herdado de Task)
Version	Membro preterido; consulte Comentários. *** Retorna a versão da tarefa. Esta propriedade é somente para leitura. (Herdado de Task)

Métodos

AcceptBreakpointManager(BreakpointManager)
CanUpdate(String)	Membro preterido; consulte Comentários. Um booliano que indica se o novo XML do pacote pode atualizar o XML do pacote antigo. (Herdado de Task)
Equals(Object)	Determina se duas instâncias de objeto são iguais. (Herdado de DtsObject)
Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object)
GetConnectionID(Connections, String)	Obtém uma cadeia de caracteres que contém a ID da conexão. (Herdado de Task)
GetConnectionName(Connections, String)	Obtém uma cadeia de caracteres que contém o nome da conexão. (Herdado de Task)
GetHashCode()	Retorna o código hash para a instância. (Herdado de DtsObject)
InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker)	Inicializa as propriedades associadas à tarefa. Esse método é chamado pelo runtime e não é usado em código. (Herdado de Task)
LoadFromXML(XmlElement, IDTSInfoEvents)
ResumeExecution()
SaveToXML(XmlDocument, IDTSInfoEvents)
SuspendExecution()
Update(String)	Membro preterido; consulte Comentários. Esse método atualiza o XML do pacote antigo com o novo XML do pacote se CanUpdate(String) for definido como true. (Herdado de Task)
Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging)
ValidateExpression(VariableDispenser)

Aplica-se a

Compartilhar via