Właściwość Package.Warnings
Zwraca kolekcja ostrzeżenia zestaw pakiet.To pole jest tylko do odczytu.
Przestrzeń nazw: Microsoft.SqlServer.Dts.Runtime
Zestaw: Microsoft.SqlServer.ManagedDTS (w Microsoft.SqlServer.ManagedDTS.dll)
Składnia
'Deklaracja
<BrowsableAttribute(False)> _
Public ReadOnly Property Warnings As DtsWarnings
Get
'Użycie
Dim instance As Package
Dim value As DtsWarnings
value = instance.Warnings
[BrowsableAttribute(false)]
public DtsWarnings Warnings { get; }
[BrowsableAttribute(false)]
public:
property DtsWarnings^ Warnings {
DtsWarnings^ get ();
}
[<BrowsableAttribute(false)>]
member Warnings : DtsWarnings
function get Warnings () : DtsWarnings
Wartość właściwości
Typ: Microsoft.SqlServer.Dts.Runtime.DtsWarnings
A DtsWarnings kolekcja.
Przykłady
Poniższy przykład kodu dodaje dwa zadania do pakiet i ustawia każdego ostrzeżenia.Przykład kodu pokazuje następnie, że ostrzeżenia również zostały dodane do pakiet Warnings kolekcja.
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
Przykładowe dane wyjściowe:
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