Jaa

DtsWarning.HelpFile Property

  • Artikkeli

Gets or sets a String expression that contains the fully qualified path to a Help file.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

Syntax

'Declaration
Public Property HelpFile As String

public string HelpFile { get; set; }

public:
property String^ HelpFile {
    String^ get ();
    void set (String^ value);
}

/** @property */
public String get_HelpFile ()

/** @property */
public void set_HelpFile (String value)

public function get HelpFile () : String

public function set HelpFile (value : String)

Property Value

A String that contains the fully qualified path of the Help file.

Remarks

If a Help file is specified by the HelpFile property, it is automatically called when the user presses the Help key (or the F1 key) in the error message dialog box. If the HelpContext property contains a valid context ID for the specified file, that topic is automatically displayed.

Example

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.

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

Imports System
Imports System.Collections.Generic
Imports System.Text
Imports Microsoft.SqlServer.Dts.Runtime
Imports Microsoft.SqlServer.Dts.Tasks.SendMailTask
 
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/2005 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/2005 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/2005 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/2005 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/2005 5:24:42 PM

ErrorCode -1073594105

Number of warnings after clearing: 0

Number of Errors after clearing: 0

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

DtsWarning Class
DtsWarning Members
Microsoft.SqlServer.Dts.Runtime Namespace