SSIS Engine Output
When the SSIS engine completes, the "OnSubmittalActioned" event is triggered. This event occurs regardless of whether the process has succeeded or has failed.
This event has the following signature:
Parameter | Data Type | Description |
---|---|---|
@ps_sender | NVARCHAR(255) | Indicates the origin of the event, for example "Submittal" |
@pi_called_by | INT | The Session ID of the user calling the event |
@pi_document_id | INT | The ID of the Submittal document |
@ps_behavior | NVARCHAR (255) | Indicates the activity that triggered the event. |
@ps_process_complete | NVARCHAR(1) | Valid values are:
Y - Process completed N - Process did not complete |
@ps_message | NVARCHAR(2000) | The output message from the engine specifying errors encountered during processing |