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 it serverConnections.xlsx, and place it in the Files folder in the SSIS Project folder.
How to do it...
Create a SSIS project and name it
R02_Breakpoints Debugging the Control Flow.Add the following variables with data types and valid default values...
