Execute Process Task Doesnt Display Text | SSIS

3
votes

I have a Foreach Container in which I have a Execute Process Task . I have many Console.WriteLine() statements in it.

The 3 images highlighted in the image can be used to get output from .exe .

I declared a variable in package to get error message from Execute Process Task by using StandardErrorVariable .

The problem is the Screen Fades Out, it doesnt display anything on screen , this happens not only when i use StandardErrorVariable but other properties highlighted in figure.

Also even though we get values into variables , the lock on them is not getting released so i am unable to use them anywhere in the package.

Also it will be helpful if you can redirect me to exact usage of all 3 variables highlighted

enter image description here

1
ssisssis-2012ssis-2008

1 Answers

0
votes

Does this happen when the package is run from a server catalog as well as visual studios? If you add a breakpoint, all vars will show up under the 'locals' window.

enter image description here

enter image description here