DtsContainer.StopTime Property

Reference

Definition

Namespace:: Microsoft.SqlServer.Dts.Runtime

Assembly:: Microsoft.SqlServer.ManagedDTS.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 property DateTime StopTime { DateTime get(); };

[System.ComponentModel.Browsable(false)]
public DateTime StopTime { get; }

[<System.ComponentModel.Browsable(false)>]
member this.StopTime : DateTime

Public ReadOnly Property StopTime As DateTime

Property Value

DateTime

A DateTime value that indicates when the container completed.

Implements

StopTime

Attributes: BrowsableAttribute

Examples

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

Applies to

Udostępnij za pośrednictwem