Loome Integrate offers a set of standard parameters that may be added to Stored Procedures, or defined as variables in SSIS Packages. These parameters do not need to be defined in the Parameters and Dependency section of a task.
When each task in a job is run it is assigned a Process Execution ID.
For Stored Procedures, the Process Execution ID can be included through the use of the _@ProcessExecutionID parameter.
In an SSIS Package, the ProcessExecutionID variable can be used to obtain the Process Execution ID.
When the Job runs, Loome Integrate will pass in the value for that Execution Batch. When each task in a job is run it is assigned a Process Execution ID.
Loome Integrate can log a number of different types of Row Counts for each Stored Procedure or SSIS task that is run.
These are:
These Row Counts can be logged by using the following OUTPUT parameters in a Stored procedure task:
They can also be included in SSIS Packages as variables and set using the Row Count transformation or through code.
Data Migration tasks will only log Inserted Rows and Deleted Rows.
The results of Row Counts can be viewed in the Execution History.