Why SSIS logging does not work in a script / script task when inside a Foreach container

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.

+1
ssis
source share

No one has answered this question yet.

See similar questions:

8
SSIS: Why is this not logged?

or similar:

3
SSIS script error handling
one
sql execution inside ssis script task not working
one
Return the result of a task from a data flow task to a script component
one
Is there a problem in SSIS with logging only child tasks, but not its parent container?
one
SSIS script task not working on second iteration of ForEach Loop Container
one
Using an SSIS Script Component as a Source
0
SSIS Data Flow Fails ONLY When Cycles Inside the Loop Container
0
SSIS Excel connection string not updated with enumerated file when running inside foreach loop container using aC # script task
0
The breakpoint in the SSIS script task that is inside the ForEach loop
0
Unable to get variable value inside script task in SSIS

Source: https://habr.com/ru/post/649811/


All Articles