I have an SSIS package that has a ForEach container (for looping through multiple files).
Outside of the loop, I also have a script task where I use the Dts.Log () function to register some information. It works great.
Inside the loop, I have several tasks, such as a task script task and a data stream. I am using Dts.Log () in another script task, but it doesn't write anything. I checked all the logging options and they seem to be correct.
Inside the data stream, I also have one script component where I try to use this Log () function without success. Once again I checked the settings and they seem to be configured correctly (according to this SSIS: why is this not logging? ).
I can enter the loop by raising events (FireInformation http://technet.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.idtscomponentevents.fireinformation(v=sql.105).aspx )
I remember reading somewhere that there are some limitations in debugging when inside a foreach container. So is there anything in Logging or is it something else?
I cannot provide any code samples (at least not now), so we need to keep the discussion at a certain level.
ssis
kivikall
source share