IDTSExecutionMetrics.StartTime Property

  • Article

 

Applies To: SQL Server 2016 Preview

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

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

Syntax

DateTime StartTime { get; }

property DateTime StartTime {
    DateTime get();
}

abstract StartTime : DateTime with get

ReadOnly Property StartTime As Date

Property Value

Type: System.DateTime

A DateTime value that indicates when the container started running.

Examples

Legacy Code Example

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

See Also

IDTSExecutionMetrics Interface
Microsoft.SqlServer.Dts.Runtime Namespace

Return to top