Export (0) Print
Expand All

Logging in the Script Component

Logging in Integration Services packages lets you save detailed information about execution progress, results, and problems by recording predefined events or user-defined messages for later analysis. The Script component can use the Log method of the ScriptMain class to log user-defined data. If logging is enabled, and the ScriptComponentLogEntry event is selected for logging on the Details tab of the Configure SSIS Logs dialog box, a single call to the Log method stores the event information in all the log providers that have been configured for the data flow task.

Here is a simple example of logging:

Dim bt(0) As Byte

Me.Log("Test Log Event", _

0, _

bt)

NoteNote

Although you can perform logging directly from your Script component, you may want to consider implementing events rather than logging. When using events, not only can you enable the logging of event messages, but you can respond to the event with default or user-defined event handlers.

For more information about logging, see Logging Package Execution.

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Community Additions

ADD
Show:
© 2014 Microsoft