SSIS: Why is this not logged?

Question

I don't know if this will help, but I included logging in the text file test.txt on my C drive.

Public Sub Main() Dim rowsProcessed As Integer = 100 Dim emptyBytes(0) As Byte Dts.Log("Testing, Test 1,2,3", rowsProcessed.ToString, emptyBytes) Dts.TaskResult = ScriptResults.Success End Sub 

Answer 1

You need to go into the SSIS-> Logging menu and mark the checkboxes as crazy checkbox-ticking-ninja to make this work.

There are various checkboxes that need to be checked, and some of them appear only when you click on a script task, so it took me a while to figure this out:

• First, enable the registry provider (which you configured, right?) By checking the box on the "Providers and Journals" tab.
• Then go to the Details tab (which shows the various events that you want to record)
• For the DTS.Log() method, you need the ScriptTaskLogEntry event, but they only appear when you click the Tasks script in the tree on the left.
• So, click each of the script tasks in the tree on the left, enable it for logging, and then mark the Tasks script in the details tab.
• Also make sure your logging provider is checked for each script task

See also: http://msdn.microsoft.com/en-us/library/ms136131.aspx

Answer 2

This is an old question, and @codeulike answered it well, but I would like to add a note about the behavior of the log in debug mode, especially for someone new to maintaining SSIS or SSIS (like me). Assuming that you have all the configuration necessary for logging, if the selected task that you plan to register is running, it will not be registered anyway. Only if you execute (or debug) the whole package, then the log will work.