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_Progress
and
Execution Results
Tab
.Rename the existent
package.dtsx
toP01_Error
in Control Flow.Add an Execute SQL Task in Control Flow; create a new OLE DB Connection to
AdventureWorks2012
in...