Package.Warnings Propriedade

Definição

Namespace:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Obtém a coleção de avisos definidos no pacote. Este campo é somente leitura.

public:
 property Microsoft::SqlServer::Dts::Runtime::DtsWarnings ^ Warnings { Microsoft::SqlServer::Dts::Runtime::DtsWarnings ^ get(); };

[System.ComponentModel.Browsable(false)]
public Microsoft.SqlServer.Dts.Runtime.DtsWarnings Warnings { get; }

[<System.ComponentModel.Browsable(false)>]
member this.Warnings : Microsoft.SqlServer.Dts.Runtime.DtsWarnings

Public ReadOnly Property Warnings As DtsWarnings

Valor da propriedade

DtsWarnings

O conjunto de coleta DtsWarnings do pacote.

Atributos

BrowsableAttribute

Exemplos

O exemplo de código a seguir adiciona duas tarefas ao pacote e define um aviso em cada uma delas. O exemplo de código mostra que os avisos também foram adicionados à coleção de pacotes Warnings .

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

namespace DtsWarning_API  
{  
    class Program  
    {  
        static void Main(string[] args)  
        {  
            Package package = new Package();  
            int pkgWarnCnt = package.Warnings.Count;  
            Console.WriteLine("Package warnings count:  {0}", pkgWarnCnt);  

            TaskHost taskH1 = (TaskHost)package.Executables.Add("STOCK:BulkInsertTask");  
            TaskHost taskH2 = (TaskHost)package.Executables.Add("STOCK:SendMailTask");  
            DtsEventHandler eh = (DtsEventHandler)taskH1.EventHandlers.Add("OnWarning");  
            eh = (DtsEventHandler)taskH2.EventHandlers.Add("OnWarning");  

            // Test that errors were successfully be added to the collection  
            package.Execute();  

            if (package.Warnings.Count >= 2)  
            {  
                pkgWarnCnt = package.Warnings.Count;  
                Console.WriteLine("Package warnings count after:  {0}", pkgWarnCnt);  
                Console.WriteLine("Description {0}", package.Warnings[0].Description);  
                Console.WriteLine("WarningCode {0}", package.Warnings[0].WarningCode);  
                Console.WriteLine("HelpContext {0}", package.Warnings[0].HelpContext);  
                Console.WriteLine("HelpFile {0}", package.Warnings[0].HelpFile);  
                Console.WriteLine("IDOfInterfaceWithWarning {0}", package.Warnings[0].IDOfInterfaceWithWarning);  

                Console.WriteLine("Test that Warnings can be added to the collection, TRUE");  
            }  
            else  
                Console.WriteLine("Test that Warnings can be added to the collection, FAILED");  
        }  
    }  
}  

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

Namespace DtsWarning_API  
    Class Program  
        Shared  Sub Main(ByVal args() As String)  
            Dim package As Package =  New Package()   
            Dim pkgWarnCnt As Integer =  package.Warnings.Count   
            Console.WriteLine("Package warnings count:  {0}", pkgWarnCnt)  

            Dim taskH1 As TaskHost = CType(package.Executables.Add("STOCK:BulkInsertTask"), TaskHost)  
            Dim taskH2 As TaskHost = CType(package.Executables.Add("STOCK:SendMailTask"), TaskHost)  
            Dim eh As DtsEventHandler = CType(taskH1.EventHandlers.Add("OnWarning"), DtsEventHandler)  
            eh = CType(taskH2.EventHandlers.Add("OnWarning"), DtsEventHandler)  

            ' Test that errors were successfully be added to the collection  
            package.Execute()  

            If package.Warnings.Count >= 2 Then  
                pkgWarnCnt = package.Warnings.Count  
                Console.WriteLine("Package warnings count after:  {0}", pkgWarnCnt)  
                Console.WriteLine("Description {0}", package.Warnings(0).Description)  
                Console.WriteLine("WarningCode {0}", package.Warnings(0).WarningCode)  
                Console.WriteLine("HelpContext {0}", package.Warnings(0).HelpContext)  
                Console.WriteLine("HelpFile {0}", package.Warnings(0).HelpFile)  
                Console.WriteLine("IDOfInterfaceWithWarning {0}", package.Warnings(0).IDOfInterfaceWithWarning)  
                Console.WriteLine("Test that Warnings can be added to the collection, TRUE")  
            Else   
                Console.WriteLine("Test that Warnings can be added to the collection, FAILED")  
            End If  
        End Sub  
    End Class  
End Namespace  

Saída de exemplo:

Package warnings count: 0

Package warnings count after: 2

Description The address in the From line is not formed correctly. It is missing an @ or it is not valid.

WarningCode 0

HelpContext 0

HelpFile

IDOfInterfaceWithWarning {8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

Test that Warnings can be added to the collection, TRUE