How to send output from Excecute Process Task to stdout?

Question

I've got an Execute Process Task that is failing. I'm capturing the output in StandardOutputVariable. Right now when the package fails it just says it failed at Execute Process Task with no helpful information. The StandardOutputVariable holds the exact failure message. I'd like that message to be in stdout. How do I do that?

does this help https://stackoverflow.com/a/57613202/10376537 — Tim Mylott, Mar 01 '23 at 16:11

score 1 · Accepted Answer · answered Mar 01 '23 at 14:32

1

You can add a TaskFailed event handler to your "Execute Process Task" with a "Script Task" that fires a DTS event (Information, Warning or Error) with the content of the StandardOutputVariable as the event message.

answered Mar 01 '23 at 14:32

Paolo de Sinno

61
4

How to send output from Excecute Process Task to stdout?

1 Answers1