DTS supports three kinds of logging: data lineage logging, package execution logging, and error logging.
Data lineage logging—. Allows you to log all the data in the destination, the source, and any transformations applied. This is covered in much more detail in Chapter 18, “Data Lineage.”
Package execution logging—. Is set in the package properties; it logs package and step information. For more information, please refer to Chapter 7, “Package.”
Error logging—. Is a text-file log of the error and the current values at the time of the error. This has been expanded in SQL Server 2000 and is covered in more ...