Duplicate logging in SSIS
I am having a problem where duplicate log statements are being written to a log file (as defined by a log provider).
I believe that this is because in the logging dialog box, I have ticked the checkbox next toa child task to override the logging functionality.
I need to do this because it is a script task and I want to capture "ScriptTaskLogEntry" events (something that I cannot do at the parent level).
However by doing this I seem to get the script eventswritten at the parent, as well as at the Script Task level.
Is there any way of avoiding this, but still capturing the log events from the script task?
Another issue that is possibly linked is that I am getting an error from the log provider:
The SSIS logging provider "SSIS log provider for Text files" failed with error code 0x800700EA ((null)). This indicates a logging error attributable to the specified log provider.
Could this be because of the parent and child task are both attempting to write to the same log provider?
Thanks in advance
October 12th, 2007 7:43pm
To avoid writing ScriptTaskLogEntry event logs at the package level, ensure that the Package and the Script Task are writing to different logs.
For example, in my package that includes a Script Task, I added 2 log providers for text files("Configure SSIS Logs" dialog). In theContainersarea, I selected the ScriptTask and selected one log provider, and then selected the Package and selected the other log provider.
Free Windows Admin Tool Kit Click here and download it now
October 13th, 2007 4:36am
Surely this will lead to a proliferation of little log files. Is there another solution, other than logging to SQL Server or the Windows Event Log?
October 13th, 2007 6:31pm
Yes thanks for the suggestion but this doesn't seem ideal. I must be missing something about how the hierarchy works. It seems strange that I can't view script task log events without putting a check against that task and therefore getting duplicate entries in the log.
Free Windows Admin Tool Kit Click here and download it now
October 16th, 2007 5:27pm
If you do the following, the script task log event should only be written once to the log, for the Script Task:
Highlight the Package container in the Containers pane, in the Configure SSIS Logs dialog box, and then add a log provider. Do not place a check mark next to the Package container.
Place a check mark next to the Script Task containerin the Containers pane in the dialog box.
Highlight Script Task in the the Containers pane, andthen selectthe log provideron the Providers and Logs tab.
Select the ScriptTaskLogEntry eventon the Details tab.
Click OK to save the changes.
October 17th, 2007 5:59am
See this Article about implementing
ssis logging various ways.
http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx
SSIS-Tutorials-FAQs |
Convert DTS to SSIS |
Document SSIS |
SSIS Tasks |
Real-time SSIS Monitoring
Free Windows Admin Tool Kit Click here and download it now
May 2nd, 2011 1:09pm