DtsErrors.Contains(Object) Método

Definição

Namespace:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Retorna um Boolean que indica se os itens na coleção podem ser acessados usando indexação sem gerar uma exceção.

public:
 bool Contains(System::Object ^ index);

public bool Contains (object index);

member this.Contains : obj -> bool

Public Function Contains (index As Object) As Boolean

Parâmetros

index

Object

O número do erro, o índice ou a descrição do código do objeto DtsError.

Retornos

Boolean

Um booliano que indica se a coleção pode ser acessada por código de descrição, número de erro ou índice. Um valor verdadeiro indica que a coleção pode ser acessada usando a sintaxe DtsErrors[index]. Um valor falso indica que a indexação não pode ser usada para recuperar itens da DtsErrors coleção.

Exemplos

O exemplo de código a seguir cria uma tarefa Enviar Email e a adiciona a um pacote. Nem todas as propriedades necessárias da tarefa Enviar Email são definidas, portanto, quando o pacote é executado, há erros e avisos nas coleções e DtsWarnings nas DtsErrors coleções. O Contains método é usado para ver se as coleções podem ser acessadas usando a DtsErrors[index] sintaxe e, nesse caso, obtém algumas propriedades usando essa sintaxe.

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  

Saída de exemplo:

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