Aracılığıyla paylaş

  • Makale

DtsContainer.ExecutionDuration Özelliği

Miktarını gösteren bir değeri döndürür saat kapsayıcı içinde milisaniye cinsinden yürütme harcanan.Bu özellik salt okunurdur.

Ad Alanı:  Microsoft.SqlServer.Dts.Runtime
Derleme:  Microsoft.SqlServer.ManagedDTS (Microsoft.SqlServer.ManagedDTS içinde.dll)

Sözdizimi

'Bildirim
Public ReadOnly Property ExecutionDuration As Integer
    Get
'Kullanım
Dim instance As DtsContainer
Dim value As Integer

value = instance.ExecutionDuration

public int ExecutionDuration { get; }

public:
virtual property int ExecutionDuration {
    int get () sealed;
}

abstract ExecutionDuration : int
override ExecutionDuration : int

final function get ExecutionDuration () : int

Özellik Değeri

Tür: System.Int32
Bir tamsayý içeren saat kapsayıcı yürütme harcanan.saat Milisaniye cinsinden verilir.

Uygulamalar

IDTSExecutionMetrics.ExecutionDuration

Örnekler

Aşağıdaki kod örneği var olan paket çalıştırır, daha sonra ne kadar süreyle paket, milisaniye cinsinden çalıştı gösterir.Çıktı da görüntüler ExecutionResult.

using System;
using System.Collections.Generic;
using System.Text;
using Microsoft.SqlServer.Dts.Runtime;

namespace Microsoft.SqlServer.SSIS.Samples
{
    class Program
    {
        static void Main(string[] args)
        {
            // The package is the ExecuteProcess package sample 
            // that is installed with the SSIS samples.
            string pkg = @"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\bin\UsingExecuteProcess.dtsx";

            Application app = new Application();
            Package p1 = app.LoadPackage(pkg, null);

            // Show the properties inherited from DtsContainer.
            Console.WriteLine("ExecutionDuration:    {0}", p1.ExecutionDuration);

            // Run the package, then review the execution duration.
            p1.Execute();
            Console.WriteLine("ExecutionDuration:    {0}", p1.ExecutionDuration);
            // Also, review the execution result.
            Console.WriteLine("ExecutionResult:   {0}", p1.ExecutionResult);
        }
    }
}

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
 
Namespace Microsoft.SqlServer.SSIS.Samples
    Class Program
        Shared  Sub Main(ByVal args() As String)
            ' The package is the ExecuteProcess package sample 
            ' that is installed with the SSIS samples.
            Dim pkg As String =  "C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services\Package Samples\ExecuteProcess Sample\ExecuteProcess\bin\UsingExecuteProcess.dtsx" 
 
            Dim app As Application =  New Application() 
            Dim p1 As Package =  app.LoadPackage(pkg,Nothing) 
 
            ' Show the properties inherited from DtsContainer.
            Console.WriteLine("ExecutionDuration:    {0}", p1.ExecutionDuration)
 
            ' Run the package, then review the execution duration.
            p1.Execute()
            Console.WriteLine("ExecutionDuration:    {0}", p1.ExecutionDuration)
            ' Also, review the execution result.
            Console.WriteLine("ExecutionResult:   {0}", p1.ExecutionResult)
        End Sub
    End Class
End Namespace

Örnek Çıktı:

ExecutionDuration: 0

ExecutionDuration: 172

ExecutionResult: Success