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

Breakpoints, Debugging the Control Flow

The debugging environment needs more powerful features than a simple logging such as the Progress or Execution Results tab. Breakpoints is one of the popular debugging methods which is very well known by software developers. Fortunately the SSIS has the ability to use breakpoints in Control Flow and in Script Task.

In this recipe, we will show how to use breakpoints in Control Flow. The scenario is that in an Excel file, connection properties of some SQL Servers exists. In a Foreach Loop, we will find out the server which has the most up-to-date version of SQL Server.

Getting ready

Create an Excel file which has connection information (Servername, Username, Password) of more than one existing SQL Servers. Name ...

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