DtsContainer.ExecutionResult Propriété

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

Valeur de propriété

Retourne une énumération DTSExecResult.

Attributs

LocalizablePropertyCategoryAttribute LocalizablePropertyDescriptionAttribute

Exemples

L’exemple de code suivant exécute un package existant, puis montre la durée pendant laquelle le package a été exécuté en millisecondes. La sortie affiche également le 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  

Exemple de sortie :

ExecutionDuration : 0

ExecutionDuration : 172

ExecutionResult : Réussite

Remarques

En plus de déterminer si le package ou le parent échoue ou réussit, l’état du résultat d’exécution est important lorsque vous avez des contraintes de priorité définies dans le package pour contrôler le flux des tâches dans le package. L’élément de priorité est la tâche ou le conteneur dont le résultat d’exécution détermine si la tâche ou le conteneur suivant, l’élément contraint, s’exécute.

S’applique à