When you configure a session or workflow to archive session logs or workflow logs, the Integration Service saves those logs in local directories. The repository also creates an entry for each saved workflow log and session log. If you move or delete a session log or workflow log from the workflow log directory or session log directory, you can remove the entries from the repository.
Use the Repository Manager to truncate the list of workflow logs for workflows that have completed. You can also use the
TruncateLog command to truncate workflow logs.
You can truncate all log entries for a workflow or log entries that were created before a specified date. You cannot truncate a workflow log for a workflow that is still running. The Repository Service truncates the workflow log list and the session log list at the same time.
When the Repository Service truncates log entries for sessions and workflows, it also deletes the following run-time information for the sessions and workflows:
Source and target statistics
You can truncate log entries to reduce the size of the repository in the database. The log entries can use a significant amount of space in the repository.
When you truncate log entries from a Microsoft SQL Server repository, verify that no workflow is running. If you truncate log entries when a workflow is running, the workflow fails.
To truncate workflow and session log entries: