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


Метод ScriptObjectModel.Log

Logs an entry to all enabled log providers.

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

Синтаксис

'Декларация
Public Sub Log ( _
    messageText As String, _
    dataCode As Integer, _
    dataBytes As Byte() _
)
'Применение
Dim instance As ScriptObjectModel 
Dim messageText As String 
Dim dataCode As Integer 
Dim dataBytes As Byte()

instance.Log(messageText, dataCode, dataBytes)
public void Log(
    string messageText,
    int dataCode,
    byte[] dataBytes
)
public:
void Log(
    String^ messageText, 
    int dataCode, 
    array<unsigned char>^ dataBytes
)
member Log : 
        messageText:string * 
        dataCode:int * 
        dataBytes:byte[] -> unit
public function Log(
    messageText : String, 
    dataCode : int, 
    dataBytes : byte[]
)

Параметры

  • messageText
    Тип: System.String
    The text of the logging entry.
  • dataCode
    Тип: System.Int32
    A field available for numeric data to be logged.
  • dataBytes
    Тип: array<System.Byte[]
    A field available for binary data to be logged.

Замечания

Use the #ctor(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object, String, String) 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 = ScriptResults.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 = ScriptResults.Failure
    End Try

End Sub

См. также

Справочник

ScriptObjectModel Класс

Пространство имен Microsoft.SqlServer.Dts.Tasks.ScriptTask