After the Integration Service loads data to the target, you want to display the system date to an output file. In the connection object, you configure the following user variable:
In the control file, you configure the following:
DISPLAY ‘&SYSDATE’ TO FILE ‘:CF.OutputFileName’
When you run the session, the Integration Service replaces :CF.OutputFileName with output_file.txt in the control file.