Use built-in session parameters to get run-time information such as folder name, Integration Service name, and source and target table name. You can use built-in session parameters in post-session shell commands, SQL commands, and email messages. You can also use them in input fields in the Designer and Workflow Manager that accept session parameters.
For example, you want to send a post-session email after session “s_UpdateCustInfo” completes that includes session run statistics for Source Qualifier “SQ_Customers” and target “T_CustInfo.” Enter the following text in the body of the email message:
Statistics for session $PMSessionName
Integration service: $PMIntegrationServiceName
Source number of affected rows: $PMSQ_Customers@numAffectedRows
Source number of dropped rows: $PMSQ_Customers@numRejectedRows
Target number of affected rows: $PMT_CustInfo@numAffectedRows
Target number of applied rows: $PMT_CustInfo@numAppliedRows
Target number of rejected rows: $PMT_CustInfo@numRejectedRows
You can also use email variables to get the session name, Integration Service name, number of rows loaded, and number of rows rejected.