SSIS: Why is this not logging?

I don't know if this will help, but i enabled logging to a text file called test.txt on my C Drive.

Public Sub Main()
    Dim rowsProcessed As Integer = 100
    Dim emptyBytes(0)开发者_StackOverflow As Byte

    Dts.Log("Testing, Test 1,2,3", rowsProcessed.ToString, emptyBytes)

    Dts.TaskResult = ScriptResults.Success
End Sub

You have to go into the SSIS->Logging menu and tick checkboxes like a crazy checkbox-ticking-ninja to get this to work.

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

• First, enable your logging provider (that you have set up, right?) by ticking it on the Providers and Logs tab.
• Then switch to the Details tab (which shows various events that you might want to log)
• For the DTS.Log() method you need the ScriptTaskLogEntry event, but they only show up when you click on Script Tasks in the tree on the left.
• So, click each of your Script Tasks in the tree on the left, enable it for logging, and then tick the Script Tasks event on the details tab.
• Also make sure your logging provider is ticked for each script task

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

This is an old question and @codeulike has answered it well but I would like to add a note about the logging behavior in debug mode, specially for someone new to SSIS or SSIS logging (like me) - Assuming you have all the configuration in place required for logging, if execute a selected task that you expect to log, it still will not log. Only if you execute (or debug) the entire package, then the logging will work.

If you are sure you have done configured everything correctly and still cant see your dbo.sysssislog in the database you selected, then check in the following YourDatabase > tables > system tables

you can find your loggings there.

its my first time doing package loggings and configured everything correctly and could not see that dbo.sysssislog in the database it was supposed to do loggings and banging my head for half an hour when i realised it was in system tables of that particular database.

I realize that this question is rather old, but maybe it helps someone.

I ran into the same problem - while debugging in Visual Studio my textfile logging provider just did not write into the configured logfile.

My logfile was in the directory "project-directory/bin/development".

After changing the path to "project-directory-name"-root (eg. "/project-directory-name/test.txt" it worked.

I cannot explain this - it is just what I have observed.