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


ScriptObjectModel.Log Method

Logs an entry to all enabled log providers.

Пространство имен: Microsoft.SqlServer.Dts.Tasks.ScriptTask
Сборка: Microsoft.SqlServer.ScriptTask (in microsoft.sqlserver.scripttask.dll)

Синтаксис

'Декларация
Public Sub Log ( _
    messageText As String, _
    dataCode As Integer, _
    dataBytes As Byte() _
)
public void Log (
    string messageText,
    int dataCode,
    byte[] dataBytes
)
public:
void Log (
    String^ messageText, 
    int dataCode, 
    array<unsigned char>^ dataBytes
)
public void Log (
    String messageText, 
    int dataCode, 
    byte[] dataBytes
)
public function Log (
    messageText : String, 
    dataCode : int, 
    dataBytes : byte[]
)

Параметры

  • messageText
    The text of the logging entry.
  • dataCode
    A field available for numeric data to be logged.
  • dataBytes
    A field available for binary data to be logged.

Замечания

Use the ScriptObjectModel method of the Dts object in Script task code to perform logging to any log providers that are enabled.

Пример

The following sample of code for use inside a Script task demonstrates logging from the Script task by recording a value that represents the number of rows processed.

[Visual Basic]
Public Sub Main()

    Dim rowsProcessed As Integer = 100
    Dim emptyBytes(0) As Byte

    Try
        Dts.Log("Rows processed: " & rowsProcessed.ToString, _
            0, _
            emptyBytes)
        Dts.TaskResult = Dts.Results.Success
    Catch ex As Exception
        'An error occurred.
        Dts.Events.FireError(0, "Script Task Example", _
            ex.Message & ControlChars.CrLf & ex.StackTrace, _
            String.Empty, 0)
        Dts.TaskResult = Dts.Results.Failure
    End Try

End Sub

Синхронизация потоков

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.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

ScriptObjectModel Class
ScriptObjectModel Members
Microsoft.SqlServer.Dts.Tasks.ScriptTask Namespace