Additional Parameters

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.

Process Execution ID

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.

Row Counts

Loome Integrate can log a number of different types of Row Counts for each Stored Procedure or SSIS task that is run.

These are:

  • Inserted rows
  • Updated rows
  • Deleted rows
  • Error rows
  • Source rows
  • Warning rows

These Row Counts can be logged by using the following OUTPUT parameters in a Stored procedure task:

  • @sInsertCount,
  • @sUpdateCount
  • @sDeleteCount
  • @sErrorCount
  • @sSourceCount
  • @sWarningCount

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.