Lire en anglais

Partager via


DtsError.HelpContext Propriété

Définition

Obtient ou définit l'ID du contexte d'aide.

public int HelpContext { get; set; }

Valeur de propriété

Entier qui contient l’identificateur de contexte d’aide.

Exemples

L’exemple de code suivant ajoute une tâche à un package, définit certaines propriétés pour le package. Le package est ensuite exécuté, et les propriétés des erreurs et des avertissements trouvés dans les collections et DtsErrors les DtsWarnings erreurs sont affichées.

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

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);  
        }  
    }  
}  

Exemple de sortie :

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

S’applique à