Progress and Execution Results tab shows some useful information about the package running, validation phases, warnings and errors, and their description. For a SSIS developer who wants to troubleshoot his package these tabs have a lot of useful information.
In this recipe, we will take a look at how this information can be useful and how we can use it in debugging and troubleshooting of packages.
Create a text file named
R01_source.txt. Enter the following data lines in the file and then place it in the Files folder in the SSIS Project folder,
C:\SSIS\Ch09_Debugging Troubleshooting and Migrating Packages to 2012:
ID,Firstname,LastName 1,Reza,Rad 2,Pedro,Perfeito three,Mark,Dastin ...