Package.Warnings 속성

정의

네임스페이스:

Microsoft.SqlServer.Dts.Runtime

어셈블리:

Microsoft.SqlServer.ManagedDTS.dll

패키지에 대해 설정된 경고의 컬렉션을 가져옵니다. 이 필드는 읽기 전용입니다.

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

속성 값

DtsWarnings

패키지에 대해 설정된 DtsWarnings 컬렉션입니다.

특성

BrowsableAttribute

예제

다음 코드 예제에서는 패키지에 두 개의 작업을 추가하고 각각에 대해 경고를 설정합니다. 그런 다음 코드 예제에서는 경고가 패키지 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  

샘플 출력:

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