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 text file which will be stamped with the package name, date and time. 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 also log to a SQL Server table.
Logging to Text Options
After enabling this option, you will need tp specify where you wish the log files to be written to and what types of events you wish to log.
-
Select Log File Path - The path where the log files will be written. The log files will be named PackageName<Date>.Log.
-
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.