Propriété IDTSExecutionMetrics.StopTime
Returns the time that the container ended execution. This property is read-only.
Espace de noms : Microsoft.SqlServer.Dts.Runtime
Assembly : Microsoft.SqlServer.ManagedDTS (en Microsoft.SqlServer.ManagedDTS.dll)
Syntaxe
'Déclaration
ReadOnly Property StopTime As DateTime
Get
'Utilisation
Dim instance As IDTSExecutionMetrics
Dim value As DateTime
value = instance.StopTime
DateTime StopTime { get; }
property DateTime StopTime {
DateTime get ();
}
abstract StopTime : DateTime
function get StopTime () : DateTime
Valeur de propriété
Type : System.DateTime
A DateTime value that indicates when the container completed.
Exemples
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