Freigeben über


IDTSExecutionMetrics.ExecutionDuration-Eigenschaft

Returns a value that indicates the amount of time that the container spent in execution, in milliseconds. This property is read-only.

Namespace:  Microsoft.SqlServer.Dts.Runtime
Assembly:  Microsoft.SqlServer.ManagedDTS (in Microsoft.SqlServer.ManagedDTS.dll)

Syntax

'Declaration
ReadOnly Property ExecutionDuration As Integer 
    Get
'Usage
Dim instance As IDTSExecutionMetrics 
Dim value As Integer 

value = instance.ExecutionDuration
int ExecutionDuration { get; }
property int ExecutionDuration {
    int get ();
}
abstract ExecutionDuration : int
function get ExecutionDuration () : int

Eigenschaftswert

Typ: System.Int32
An Integer that contains the amount of time that the container spent executing. The time is given in milliseconds.

Beispiele

The following code example assumes a package named pkg has been created. The package is executed, and the start time, stop time, and duration of the run is recorded. The variables are created after the package is run to capture the information. The pkg object can be replaced by any container, task, or object that inherits from DtsContainer, as DtsContainer inherits the IDTSExecutionMetrics interface.

pkg.Execute();
DateTime dtStart = pkg.StartTime;
DateTime dtStop = pkg.StopTime;
int pgkDuration = pkg.ExecutionDuration;
pkg.Execute()
Dim dtStart As DateTime =  pkg.StartTime 
Dim dtStop As DateTime =  pkg.StopTime 
Dim pgkDuration As Integer =  pkg.ExecutionDuration

Siehe auch

Verweis

IDTSExecutionMetrics Schnittstelle

Microsoft.SqlServer.Dts.Runtime-Namespace