IDTSExecutionMetrics.ExecutionDuration Property

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

命名空间: Microsoft.SqlServer.Dts.Runtime
程序集: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

语法

声明
ReadOnly Property ExecutionDuration As Integer
int ExecutionDuration { get; }
property int ExecutionDuration {
    int get ();
}
/** @property */
int get_ExecutionDuration ()
function get ExecutionDuration () : int

属性值

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

示例

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

线程安全

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

平台

开发平台

有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表,请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

IDTSExecutionMetrics Interface
IDTSExecutionMetrics Members
Microsoft.SqlServer.Dts.Runtime Namespace