DtsError.TimeStamp Свойство

Ссылка

Определение

Пространство имен:: Microsoft.SqlServer.Dts.Runtime

Сборка:: Microsoft.SqlServer.ManagedDTS.dll

Важно!

Некоторые сведения относятся к предварительной версии продукта, в которую до выпуска могут быть внесены существенные изменения. Майкрософт не предоставляет никаких гарантий, явных или подразумеваемых, относительно приведенных здесь сведений.

Возвращает отметку времени, когда произошла ошибка. Это значение доступно только для чтения.

public:
 property System::Object ^ TimeStamp { System::Object ^ get(); };

public object TimeStamp { get; }

member this.TimeStamp : obj

Public ReadOnly Property TimeStamp As Object

Значение свойства

Object

Объект, который содержит отметку времени, когда произошла ошибка.

Примеры

В следующем примере кода задача добавляется в пакет, задаются некоторые свойства пакета. Затем пакет запускается, и отображаются свойства ошибок и предупреждений, обнаруженных в DtsWarnings коллекции DtsErrors .

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

Образец вывода:

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

Применяется к

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

DtsError.TimeStamp Свойство

Определение

Значение свойства

Примеры

Применяется к

Дополнительные ресурсы