SSDT-BI Debugging using SQL Server 2014 - Part 1
I will be describing
how to debug using the Microsoft SSDT-BI tool used in SQL Server 2014. I will
start from the beginning so the first couple of post will be very basic.
In this blog post I
will be setting breakpoints in SSDT. Keep in mind you can only set Breakpoints
in the Control Flow task not in Data Flow task.
I'll be using SQL
Server 2014 and the SSDT-BI tool for SSIS debugging
Download the SQL2012.Integration_Services.Create_Simple_ETL_Tutorial.Sample.zip and follow the instructions to create the solution and package.
Install the AdventureWorksDW 2012 DB (make sure you install in your 2014 DB instance)
After installing the sample ETL open the Lesson 6 package. It should look like this:
Now let's set a breakpont in
the control flow by right clicking at click Edit Breakpoints (see below)
or just press F9.
Once the breakpoint is set run the package using the debugger. You will notice a red dot with an arrow to indicate that the execution has stopped at the breakpoint.
At this point you will be able to look at variable values and other pertinent information about your package which will be reviewed in the next blog.