Metodo ExecuteSQLTask.InitializeTask

Articolo
04/26/2013

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

Spazio dei nomi Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
Assembly: Microsoft.SqlServer.SQLTask (in Microsoft.SqlServer.SQLTask.dll)

Sintassi

'Dichiarazione
Public Overrides Sub InitializeTask ( _
    connections As Connections, _
    variableDispenser As VariableDispenser, _
    events As IDTSInfoEvents, _
    log As IDTSLogging, _
    eventInfos As EventInfos, _
    logEntryInfos As LogEntryInfos, _
    refTracker As ObjectReferenceTracker _
)
'Utilizzo
Dim instance As ExecuteSQLTask 
Dim connections As Connections 
Dim variableDispenser As VariableDispenser 
Dim events As IDTSInfoEvents 
Dim log As IDTSLogging 
Dim eventInfos As EventInfos 
Dim logEntryInfos As LogEntryInfos 
Dim refTracker As ObjectReferenceTracker

instance.InitializeTask(connections, _
    variableDispenser, events, log, eventInfos, _
    logEntryInfos, refTracker)

public override void InitializeTask(
    Connections connections,
    VariableDispenser variableDispenser,
    IDTSInfoEvents events,
    IDTSLogging log,
    EventInfos eventInfos,
    LogEntryInfos logEntryInfos,
    ObjectReferenceTracker refTracker
)

public:
virtual void InitializeTask(
    Connections^ connections, 
    VariableDispenser^ variableDispenser, 
    IDTSInfoEvents^ events, 
    IDTSLogging^ log, 
    EventInfos^ eventInfos, 
    LogEntryInfos^ logEntryInfos, 
    ObjectReferenceTracker^ refTracker
) override

abstract InitializeTask : 
        connections:Connections * 
        variableDispenser:VariableDispenser * 
        events:IDTSInfoEvents * 
        log:IDTSLogging * 
        eventInfos:EventInfos * 
        logEntryInfos:LogEntryInfos * 
        refTracker:ObjectReferenceTracker -> unit  
override InitializeTask : 
        connections:Connections * 
        variableDispenser:VariableDispenser * 
        events:IDTSInfoEvents * 
        log:IDTSLogging * 
        eventInfos:EventInfos * 
        logEntryInfos:LogEntryInfos * 
        refTracker:ObjectReferenceTracker -> unit

public override function InitializeTask(
    connections : Connections, 
    variableDispenser : VariableDispenser, 
    events : IDTSInfoEvents, 
    log : IDTSLogging, 
    eventInfos : EventInfos, 
    logEntryInfos : LogEntryInfos, 
    refTracker : ObjectReferenceTracker
)

Parametri

connections
Tipo: Microsoft.SqlServer.Dts.Runtime.Connections
A Connections collection used by the task.

variableDispenser
Tipo: Microsoft.SqlServer.Dts.Runtime.VariableDispenser
A VariableDispenser object for locking variables.

events
Tipo: Microsoft.SqlServer.Dts.Runtime.IDTSInfoEvents
An IDTSComponentEvents interface to raise events.

log
Tipo: Microsoft.SqlServer.Dts.Runtime.IDTSLogging
An IDTSLogging interface.

eventInfos
Tipo: Microsoft.SqlServer.Dts.Runtime.EventInfos
A collection that contains the events to be raised during the execution of the task.

logEntryInfos
Tipo: Microsoft.SqlServer.Dts.Runtime.LogEntryInfos
A collection of log entries.

refTracker
Tipo: Microsoft.SqlServer.Dts.Runtime.ObjectReferenceTracker
An object reference tracker.

Osservazioni

For the ExecuteSQLTask and all other stock tasks, this method is used to set the log events of each task.

The run-time engine calls this method immediately after the task is created and before it performs validation, execution, or persistence operations.

Esempi

Task developers define custom events by overriding the InitializeTask method of the Task base class, and creating a new EventInfo. The following code sample shows the InitializeTask method of a custom task in which two custom events are created, and added to the EventInfos collection.

public override void InitializeTask(Connections connections, VariableDispenser variables, IDTSInfoEvents events, IDTSLogging log, EventInfos eventInfos, LogEntryInfos logEntryInfos, ObjectReferenceTracker refTracker)
{
    this.eventInfos = eventInfos;
    string[] paramNames = new string[1];
    TypeCode[] paramTypes = new TypeCode[1]{TypeCode.Int32};
    string[] paramDescriptions = new string[1];

    paramNames[0] = "InitialValue";
    paramDescriptions[0] = "The value before increment.";

    this.eventInfos.Add("OnBeforeIncrement","Fires before the task increments the value.",true,paramNames,paramTypes,paramDescriptions);
    this.onBeforeIncrement = this.eventInfos["OnBeforeIncrement"];

    paramDescriptions[0] = "The value after increment.";
    this.eventInfos.Add("OnAfterIncrement","Fires after the initial value is updated.",true,paramNames, paramTypes,paramDescriptions);
    this.onAfterIncrement = this.eventInfos["OnAfterIncrement"];
}

Vedere anche

Riferimento

ExecuteSQLTask Classe

Spazio dei nomi Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask

Condividi tramite