Поделиться через


Метод Clear

Clears all objects from the DtsWarnings collection.

Пространство имен:  Microsoft.SqlServer.Dts.Runtime
Сборка:  Microsoft.SqlServer.ManagedDTS (в Microsoft.SqlServer.ManagedDTS.dll)

Синтаксис

'Декларация
Public Sub Clear
'Применение
Dim instance As DtsWarnings

instance.Clear()
public void Clear()
public:
void Clear()
member Clear : unit -> unit 
public function Clear()

Примеры

The following code example adds a task to a package, and sets some properties for the package. The package is then run, and properties for the errors and warnings found in the DtsWarnings and DtsErrors collections are shown. The code example then clears the collection using Clear.

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

namespace Microsoft.SqlServer.SSIS.Samples
{
    class Program
    {
        static void Main(string[] args)
        {
            Package package = new Package();
            Console.WriteLine("Package warnings count: {0}", package.Warnings.Count);
            Console.WriteLine("Package errors count:   {0}", package.Errors.Count);

            TaskHost taskH2 = (TaskHost)package.Executables.Add("STOCK:SendMailTask");
            taskH2.FailPackageOnFailure = false;
            taskH2.FailParentOnFailure = false;
            Console.WriteLine("SendMailTask: {0}", taskH2.ID);
 
            // Test that warnings were successfully added to the collection.
            package.MaximumErrorCount = 100;
            package.FailPackageOnFailure = false;
            package.FailParentOnFailure = false;
            package.DelayValidation = true;
            package.Execute();

            Console.WriteLine("Package warnings count after running the package: {0}", package.Warnings.Count);
            Console.WriteLine("Package errors count after running the package:   {0}", package.Errors.Cou
            foreach (DtsWarning pkgWarning in package.Warnings)
            {
                Console.WriteLine();
                Console.WriteLine("Description  {0}", pkgWarning.Description);
                Console.WriteLine("HelpContext  {0}", pkgWarning.HelpContext);
                Console.WriteLine("HelpFile     {0}", pkgWarning.HelpFile);
                Console.WriteLine("IDOfInterfaceWithWarning {0}", pkgWarning.IDOfInterfaceWithWarning);
                Console.WriteLine("Source       {0}", pkgWarning.Source);
                Console.WriteLine("Subcomponent {0}", pkgWarning.SubComponent);
                Console.WriteLine("Timestamp    {0}", pkgWarning.TimeStamp);
                Console.WriteLine("WarningCode  {0}", pkgWarning.WarningCode);
            }

            foreach (DtsError pkgError in package.Errors)
            {
                Console.WriteLine();
                Console.WriteLine("Description  {0}", pkgError.Description);
                Console.WriteLine("HelpContext  {0}", pkgError.HelpContext);
                Console.WriteLine("HelpFile     {0}", pkgError.HelpFile);
                Console.WriteLine("IDOfInterfaceWithError {0}", pkgError.IDOfInterfaceWithError);
                Console.WriteLine("Source       {0}", pkgError.Source);
                Console.WriteLine("Subcomponent {0}", pkgError.SubComponent);
                Console.WriteLine("Timestamp    {0}", pkgError.TimeStamp);
                Console.WriteLine("ErrorCode    {0}", pkgError.ErrorCode);
            }
            // Clear the errors and warnings collections.
            Console.WriteLine();
            package.Warnings.Clear();
            Console.WriteLine("Number of warnings after clearing: {0}", package.Warnings.Count);
            package.Errors.Clear();
            Console.WriteLine("Number of Errors after clearing: {0}", package.Errors.Count);
        }
    }
}
Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask
 
Namespace Microsoft.SqlServer.SSIS.Samples
    Class Program
        Shared  Sub Main(ByVal args() As String)
            Dim package As Package =  New Package() 
            Console.WriteLine("Package warnings count: {0}", package.Warnings.Count)
            Console.WriteLine("Package errors count:   {0}", package.Errors.Count)
 
            Dim taskH2 As TaskHost = CType(package.Executables.Add("STOCK:SendMailTask"), TaskHost)
            taskH2.FailPackageOnFailure = False
            taskH2.FailParentOnFailure = False
            Console.WriteLine("SendMailTask: {0}", taskH2.ID)
 
            ' Test that warnings were successfully added to the collection.
            package.MaximumErrorCount = 100
            package.FailPackageOnFailure = False
            package.FailParentOnFailure = False
            package.DelayValidation = True
            package.Execute()
 
            Console.WriteLine("Package warnings count after running the package: {0}", package.Warnings.Count)
            Console.WriteLine("Package errors count after running the package:   {0}", package.Errors.Cou
            Dim pkgWarning As DtsWarning
            For Each pkgWarning In package.Warnings
                Console.WriteLine()
                Console.WriteLine("Description  {0}", pkgWarning.Description)
                Console.WriteLine("HelpContext  {0}", pkgWarning.HelpContext)
                Console.WriteLine("HelpFile     {0}", pkgWarning.HelpFile)
                Console.WriteLine("IDOfInterfaceWithWarning {0}", pkgWarning.IDOfInterfaceWithWarning)
                Console.WriteLine("Source       {0}", pkgWarning.Source)
                Console.WriteLine("Subcomponent {0}", pkgWarning.SubComponent)
                Console.WriteLine("Timestamp    {0}", pkgWarning.TimeStamp)
                Console.WriteLine("WarningCode  {0}", pkgWarning.WarningCode)
            Next
 
            Dim pkgError As DtsError
            For Each pkgError In package.Errors
                Console.WriteLine()
                Console.WriteLine("Description  {0}", pkgError.Description)
                Console.WriteLine("HelpContext  {0}", pkgError.HelpContext)
                Console.WriteLine("HelpFile     {0}", pkgError.HelpFile)
                Console.WriteLine("IDOfInterfaceWithError {0}", pkgError.IDOfInterfaceWithError)
                Console.WriteLine("Source       {0}", pkgError.Source)
                Console.WriteLine("Subcomponent {0}", pkgError.SubComponent)
                Console.WriteLine("Timestamp    {0}", pkgError.TimeStamp)
                Console.WriteLine("ErrorCode    {0}", pkgError.ErrorCode)
            Next
            ' Clear the errors and warnings collections.
            Console.WriteLine()
            package.Warnings.Clear()
            Console.WriteLine("Number of warnings after clearing: {0}", package.Warnings.Count)
            package.Errors.Clear()
            Console.WriteLine("Number of Errors after clearing: {0}", package.Errors.Count)
        End Sub
    End Class
End Namespace

Sample Output:

Package warnings count after running the package: 2

Package errors count after running the package: 3

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

HelpContext 0

HelpFile

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

Source {1E9FF017-4E01-4AEF-8519-4D48D954D3D1}

Subcomponent Send Mail Task

Timestamp 4/13/2008 5:24:42 PM

WarningCode 0

Description Subject is empty

HelpContext 0

HelpFile

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

Source {1E9FF017-4E01-4AEF-8519-4D48D954D3D1}

Subcomponent Send Mail Task

Timestamp 4/13/2008 5:24:42 PM

WarningCode 0

Description SMTP Server not specified

HelpContext 0

HelpFile

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

Source {1E9FF017-4E01-4AEF-8519-4D48D954D3D1}

Subcomponent Send Mail Task

Timestamp 4/13/2008 5:24:42 PM

ErrorCode 0

Description No recipient specified

HelpContext 0

HelpFile

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

Source {1E9FF017-4E01-4AEF-8519-4D48D954D3D1}

Subcomponent Send Mail Task

Timestamp 4/13/2008 5:24:42 PM

ErrorCode 0

Description There were errors during task validation.

HelpContext -1073594105

HelpFile

IDOfInterfaceWithError {8BDFE889-E9D8-4D23-9739-DA807BCDC2AC}

Source {1E9FF017-4E01-4AEF-8519-4D48D954D3D1}

Subcomponent

Timestamp 4/13/2008 5:24:42 PM

ErrorCode -1073594105

Number of warnings after clearing: 0

Number of Errors after clearing: 0