How to debug an SSIS Package after its Execution

Q:: How can we see Package Execution Process wether it is success/failure , errors, Bottle necks.?

Ans: We can observe the execution information in

2-ways            

1.      Progress Tab                2. Log Providers

1. Progress Tab:

It contains
     --How package is validated
     --Step by step execution from starting to ending
In general it displays

     --The no of rows operated

     --Sourc & Destination Connections

     --The amount of time take bw one stmt to other stmt…etc

2.Log Providers:

                           we will discuss soon...............