From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Logging SSIS package events

Logging SSIS package events - SQL Server Tutorial

From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012

Start my 1-month free trial

Logging SSIS package events

“

Logging can be a very important part of our overall strategy. Remember that when an SSIS package runs, there typically isn't going to be someone sitting there watching it run. These things kick-off automatically at a certain time everyday and there doesn't have to be an operator watching it run. Therefore, if we have problems or even if we have success, we won't know about it unless we read some sort of log. I am going to go ahead and open up the projects we have used in previous exercises and that is the ResellerPackage. I'll double-click on package.dtsx. I have the work surface come up. I still have a breakpoint in my Data Flow Task. So, I'm going to go ahead and clear that by right-clicking. Go to Edit Breakpoints and clear all the check marks. Now I'd like to add some logging to this package. In the Menu bar there is a menu item called SIS and the top option is Logging. And here the first thing I need to do is select a Logging provider. And I have some choices on this, I can do a…

Contents