DtsErrors.Item[Object] Proprietà

Definizione

Spazio dei nomi:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Restituisce un oggetto DtsError dalla raccolta.

public:
 property Microsoft::SqlServer::Dts::Runtime::DtsError ^ default[System::Object ^] { Microsoft::SqlServer::Dts::Runtime::DtsError ^ get(System::Object ^ index); };

public Microsoft.SqlServer.Dts.Runtime.DtsError this[object index] { get; }

member this.Item(obj) : Microsoft.SqlServer.Dts.Runtime.DtsError

Default Public ReadOnly Property Item(index As Object) As DtsError

Parametri

index

Object

Numero di errore, indice o descrizione dell'oggetto DtsError da restituire.

Valore della proprietà

DtsError

Un oggetto DtsError.

Esempio

Nell'esempio di codice seguente viene creata un'attività Invia messaggio e viene aggiunta a un pacchetto. Non tutte le proprietà necessarie dell'attività Invia messaggi di posta elettronica vengono impostate, pertanto, quando il pacchetto viene eseguito, sono presenti errori e avvisi nelle DtsErrors raccolte e DtsWarnings . Il Contains metodo viene usato per verificare se è possibile accedere alle raccolte usando la DtsErrors[index] sintassi e, in tal caso, ottiene alcune proprietà usando tale sintassi.

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

namespace Microsoft.SqlServer.SSIS.Samples  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Package package = new Package();  
            TaskHost taskH2 = (TaskHost)package.Executables.Add("STOCK:SendMailTask");  
            taskH2.FailPackageOnFailure = false;  
            taskH2.FailParentOnFailure = false;  
            Console.WriteLine("SendMailTask: {0}", taskH2.ID);  

            package.MaximumErrorCount = 100;  
            package.FailPackageOnFailure = false;  
            package.FailParentOnFailure = false;  
            package.DelayValidation = true;  
            package.Execute();  

            // Get the collections.  
            DtsWarnings dtsWarns = package.Warnings;  
            DtsErrors dtsErrs = package.Errors;  
            // Use Contains to see if collection can be accessed  
            // using item syntax of [x].  
            Boolean warnItem = dtsWarns.Contains(0);  
            Boolean errItem = dtsErrs.Contains(0);  

            // If item sytax can be used, use it to obtain information.  
            if (warnItem)  
            {  
            //Using the Item method syntax of [x], obtain the first entry and a description.  
            DtsWarning firstWItem = dtsWarns[0];  
            String nameOfFirstItem = dtsWarns[0].SubComponent;  

            //Print the subcomponent for the warning located at position [0] two ways.  
            Console.WriteLine("The first warning subcomponent is: {0}", firstWItem.SubComponent);  
            Console.WriteLine("The first warning subcomponent is: {0}", nameOfFirstItem);  
            }  

            // If item sytax can be used, use it to obtain information.  
            if (errItem)  
            {  
            //Using the Item method syntax of [x], obtain the first entry and a description.  
            DtsError firstEItem = dtsErrs[0];  
            String nameOfFirstItem = dtsErrs[0].Description;  

            //Print the description of the warning located at position [0] two ways.  
            Console.WriteLine("The first error description is: {0}", firstEItem.Description);  
            Console.WriteLine("The first error description is: {0}", nameOfFirstItem);  
            }  
        }  
    }  
}  

Imports System  
Imports System.Collections.Generic  
Imports System.Text  
Imports Microsoft.SqlServer.Dts.Runtime  
Imports Microsoft.SqlServer.Dts.Tasks.SendMailTask  

Namespace Microsoft.SqlServer.SSIS.Samples  
    Class Program  
        static void Main(string() args)  
        {  
            Dim package As Package =  New Package()   
            Dim taskH2 As TaskHost = CType(package.Executables.Add("STOCK:SendMailTask"), TaskHost)  
            taskH2.FailPackageOnFailure = False  
            taskH2.FailParentOnFailure = False  
            Console.WriteLine("SendMailTask: {0}", taskH2.ID)  

            package.MaximumErrorCount = 100  
            package.FailPackageOnFailure = False  
            package.FailParentOnFailure = False  
            package.DelayValidation = True  
            package.Execute()  

            ' Get the collections.  
            Dim dtsWarns As DtsWarnings =  package.Warnings   
            Dim dtsErrs As DtsErrors =  package.Errors   
            ' Use Contains to see if collection can be accessed  
            ' using item syntax of [x].  
            Dim warnItem As Boolean =  dtsWarns.Contains(0)   
            Dim errItem As Boolean =  dtsErrs.Contains(0)   

            ' If item sytax can be used, use it to obtain information.  
            if (warnItem)  
            {  
            'Using the Item method syntax of [x], obtain the first entry and a description.  
            Dim firstWItem As DtsWarning =  dtsWarns(0)   
            Dim nameOfFirstItem As String =  dtsWarns(0).SubComponent   

            'Print the subcomponent for the warning located at position [0] two ways.  
            Console.WriteLine("The first warning subcomponent is: {0}", firstWItem.SubComponent)  
            Console.WriteLine("The first warning subcomponent is: {0}", nameOfFirstItem)  
            }  

            ' If item sytax can be used, use it to obtain information.  
            if (errItem)  
            {  
            'Using the Item method syntax of [x], obtain the first entry and a description.  
            Dim firstEItem As DtsError =  dtsErrs(0)   
            Dim nameOfFirstItem As String =  dtsErrs(0).Description   

            'Print the description of the warning located at position [0] two ways.  
            Console.WriteLine("The first error description is: {0}", firstEItem.Description)  
            Console.WriteLine("The first error description is: {0}", nameOfFirstItem)  
            }  
        }  
    End Class  
End Namespace  

Esempio di output

SendMailTask: {12ADD307-23DA-42C9-A4B2-E360DEFD7563}

The first warning subcomponent is: Send Mail Task

The first warning subcomponent is: Send Mail Task

The first error description is: SMTP Server not specified

The first error description is: SMTP Server not specified

Commenti

Se la chiamata al metodo restituisce true, è possibile accedere all'elemento Contains specificato nella raccolta usando la sintassi Connections[index]. Se il Contains metodo restituisce false, questa proprietà genera un'eccezione. In C#, questa proprietà è l'indicizzatore per la classe DtsErrors.