DtsContainer.ExecutionResult 속성

정의

네임스페이스:

Microsoft.SqlServer.Dts.Runtime

어셈블리:

Microsoft.SqlServer.ManagedDTS.dll

DtsContainer 개체 실행의 성공 또는 실패를 나타내는 값을 반환합니다.

public:
 property Microsoft::SqlServer::Dts::Runtime::DTSExecResult ExecutionResult { Microsoft::SqlServer::Dts::Runtime::DTSExecResult get(); };

[Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyCategory(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PropertyCategoryExecution")]
[Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "ExecutionResultDesc")]
public Microsoft.SqlServer.Dts.Runtime.DTSExecResult ExecutionResult { get; }

[<Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyCategory(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "PropertyCategoryExecution")>]
[<Microsoft.SqlServer.Dts.Runtime.Localization.LocalizablePropertyDescription(typeof(Microsoft.SqlServer.Dts.Runtime.Localized), "ExecutionResultDesc")>]
member this.ExecutionResult : Microsoft.SqlServer.Dts.Runtime.DTSExecResult

Public ReadOnly Property ExecutionResult As DTSExecResult

속성 값

DTSExecResult

DTSExecResult 열거형을 반환합니다.

특성

LocalizablePropertyCategoryAttribute LocalizablePropertyDescriptionAttribute

예제

다음 코드 예제에서는 기존 패키지를 실행한 다음 패키지 실행 시간(밀리초)을 보여 줍니다. 출력 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  

샘플 출력:

ExecutionDuration: 0

ExecutionDuration: 172

ExecutionResult: 성공

설명

패키지 또는 부모가 실패하거나 성공하는지 확인하는 것 외에도 패키지에서 태스크 흐름을 제어하기 위해 패키지에 선행 제약 조건이 설정된 경우 실행 결과 상태가 중요합니다. 우선 순위 항목은 실행 결과가 다음 작업 또는 컨테이너, 제한된 항목이 실행되는지 여부를 결정하는 태스크 또는 컨테이너입니다.