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.

The Event Handler Logging rule enables logging into a descriptive table through event handlers for all of your packages. The enterprise logging database (SSISODS) creates a central database for your SSIS packages to log. It provides a much more robust logging interface than the default logs and is done through event handlers. After you select the database you wish to log to, the SSISEntperiseLog table will be created in the database (if it doesn’t exist). After your packages log to this table, you are also provided a data warehouse to move these log records to for trending and an Analysis Services cube for fast access.

Event Handler Logging Options

The Event Handler Logging rule tab configures where the logging table and stored procedure will be written.

• Server - The server name where your SSIS packages will log to
• Database - The database name where the log files and stored procedures will be created. If the table is already there, the Log Table text box will populate. If not, click the Create Log Table button to create the table.