Troubleshooting with Progress and Execution Results tab
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.
Getting ready
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
How to do it...
Create a SSIS project and name it
R01_ProgressandExecution ResultsTab.Rename the existent
package.dtsxtoP01_Errorin Control Flow.Add an Execute SQL Task in Control Flow; create a new OLE DB Connection to
AdventureWorks2012in...