From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
Join today to access over 24,800 courses taught by industry experts.
Debugging an SSIS package - SQL Server Tutorial
From the course: Implementing a Data Warehouse with Microsoft SQL Server 2012
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.