DtsError.Description 屬性
Gets or sets a text description for the error.
命名空間： Microsoft.SqlServer.Dts.Runtime
組件： Microsoft.SqlServer.ManagedDTS (在 Microsoft.SqlServer.ManagedDTS.dll 中)
語法
'宣告
Public Property Description As String
Get
Set
'用途
Dim instance As DtsError
Dim value As String
value = instance.Description
instance.Description = value
public string Description { get; set; }
public:
property String^ Description {
String^ get ();
void set (String^ value);
}
member Description : string with get, set
function get Description () : String
function set Description (value : String)
屬性值
型別：System.String
A String that contains text that describes the error.
範例
The following code example adds a task to a package, 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/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