Propriété DtsContainer.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
<BrowsableAttribute(False)> _
Public ReadOnly Property StopTime As DateTime 
    Get
'Utilisation
Dim instance As DtsContainer 
Dim value As DateTime 

value = instance.StopTime
[BrowsableAttribute(false)]
public DateTime StopTime { get; }
[BrowsableAttribute(false)]
public:
virtual property DateTime StopTime {
    DateTime get () sealed;
}
[<BrowsableAttribute(false)>]
abstract StopTime : DateTime
[<BrowsableAttribute(false)>]
override StopTime : DateTime
final function get StopTime () : DateTime

Valeur de propriété

Type : System.DateTime
A DateTime value that indicates when the container completed.

Implémente

IDTSExecutionMetrics.StopTime

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

Voir aussi

Référence

DtsContainer Classe

Espace de noms Microsoft.SqlServer.Dts.Runtime