Delete Package Logs

SQL Server Enterprise Manager Help

SQL Server Enterprise Manager Help

Delete Package Logs

Use this dialog box to remove Data Transformation Services (DTS) package logs. The main purpose of removing package logs is to delete the oldest logs from the system and keep the newer, more pertinent logs. The only way to force the feature to delete the newest logs in a version is by selecting the Delete most recent log check box.

Options

DTS Package available on the server <server name>

Specify the package whose logs you want to see in the tree.

Delete all the logs for the selected version <Version x> created on <mm/dd/yy hh:mm:ss AM/PM>

Specify that all the logs in the version you have highlighted will be deleted, with the exception of the most recent one. If you want all the logs for the selected version deleted without exception, you also must select the Delete most recent log check box.

Delete all the logs for the package: <package name>

Specify that all the logs for the package that you have selected will be deleted, except for the most recent log and version. If you also select the Delete most recent log check box, all package logs and versions are deleted.

Delete most recent log

Specify that only the most recent log of the selected version will be deleted. This option is selected by default.