DTS xChange has a series of enterprise-ready rules to help you migrate your DTS packages to SSIS quickly and easily. After you select the packages that you wish to migrate, you then specify the rules on the Specify Rules screen in the wizard.  

Package logging is turned off by default in SSIS. By checking this option, you can log to a database table, which will be called sysdtslogs90 or sysdtslogs100 (based on your version of SQL Server). Every time a task, container or package start, stops, or has an error or warning, a line will be written to this file. Alternatively, you can log to a text file or enable the advanced logging through event handlers.

Logging to SQL Server Options

After enabling the rule, you will need to specify where you want the log table and stored procedures to be located. A connection manager will be created in each of the converted packages that will point to this database.

• Select Event(s) you want to log - Check the events that you wish to log to the log file. It is recommended that you do the OnPreExecute, OnPostExecute, OnError and OnWarning. These first two will log anytime a package, container or task starts and finishes.