Package.Warnings Propriété

Définition

Espace de noms:

Microsoft.SqlServer.Dts.Runtime

Assembly:

Microsoft.SqlServer.ManagedDTS.dll

Obtient une collection d'avertissements définis sur le package. Ce champ est en lecture seule.

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

Valeur de propriété

DtsWarnings

Collection DtsWarnings définie sur le package.

Attributs

BrowsableAttribute

Exemples

L’exemple de code suivant ajoute deux tâches au package et définit un avertissement sur chacun d’eux. L’exemple de code montre ensuite que les avertissements ont également été ajoutés à la collection de packages 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  

Exemple de sortie :

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