O'Reilly logo

SQL Server DTS by Steve Hughes,, Steve Miller,, Marcelino Santos,, Brian Sullivan, Jim Samuelson,

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 14. Custom Error Logging with DTS

Custom Error Logging with DTS

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required