DtsError.Description Eigenschaft
Definition
Wichtig
Einige Informationen beziehen sich auf Vorabversionen, die vor dem Release ggf. grundlegend überarbeitet werden. Microsoft übernimmt hinsichtlich der hier bereitgestellten Informationen keine Gewährleistungen, seien sie ausdrücklich oder konkludent.
Ruft eine Textbeschreibung für den Fehler ab oder legt sie fest.
public:
property System::String ^ Description { System::String ^ get(); void set(System::String ^ value); };public string Description { get; set; }member this.Description : string with get, setPublic Property Description As StringEigenschaftswert
Eine Zeichenfolge, die Text enthält, der den Fehler beschreibt.
Beispiele
Im folgenden Codebeispiel wird einem Paket eine Aufgabe hinzugefügt, es werden einige Eigenschaften für das Paket festgelegt. Das Paket wird dann ausgeführt, und die Eigenschaften für die Fehler und Warnungen, die in den DtsWarnings und DtsErrors Sammlungen gefunden werden, werden angezeigt.
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
Beispielausgabe:
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