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.
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.