DtsContainer.StopTime Property

Returns the time that the container ended execution. This property is read-only.

네임스페이스: Microsoft.SqlServer.Dts.Runtime
어셈블리: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

구문

‘선언
<BrowsableAttribute(False)> _
Public ReadOnly Property StopTime As DateTime

[BrowsableAttribute(false)] 
public DateTime StopTime { get; }

[BrowsableAttribute(false)] 
public:
virtual property DateTime StopTime {
    DateTime get () sealed;
}

/** @property */
public final DateTime get_StopTime ()

public final function get StopTime () : DateTime

속성 값

A DateTime value that indicates when the container completed.

예

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 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.

참고 항목

참조

DtsContainer Class
DtsContainer Members
Microsoft.SqlServer.Dts.Runtime Namespace