O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

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 11. Event Handling and Logging

by Pedro Perfeito

In this chapter, we will cover the following topics:

  • Logging over Legacy Deployment Model
  • Logging over Project Deployment Model
  • Using event handlers and system variables for custom logging

Introduction

The logging information is very important and often underestimated. When everything works perfectly, nobody remembers that logging exists, but if it does not reverse, all eyes will be focused on logging to know what went wrong. In the production environment, the SQL Server Data Tools (SSDT) user interface, which provides useful information in real time about the rows passing through the Data Flow pipeline, will not be available. Packages are normally executed in batch mode at late night hours and ...

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