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.

Debugging an SSIS package

Debugging an SSIS package - SQL Server Tutorial

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

Start my 1-month free trial

Debugging an SSIS package

“

I'd like to talk about debugging an SSIS package. So, going to open an existing project, the ResellerPackage project we worked on previously. Quick review of that, we have one task that truncates a table in our data warehouse. Then a Data Flow Task that reloads the data into that table. The Data Flow Task is made up of three components, a Flat File Source, a Data Conversion, and then OLE DB Destination. In SQL Server Integrations Services, we can use break points to pause the execution of the package at any point. And while the package is paused, we can look at the value of different variables and parameters. We can also look at some of the data that is flowing back and forth. So, I'm going to right-click on the Data Flow Task and go to the menu option for Edit Breakpoints. I'll then have a number of choices on setting a break point on this task. I'd like to do the very first one, break when entering the on pre-execute event. So this is going to break before this executes. We also…

Contents