TechNet
Export (0) Print
Expand All

DtsContainer.StopTime Property

 

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

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

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

Property Value

Type: System.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;
Return to top
Show:
© 2016 Microsoft