Watch SSIS Variable Value inside BIDS during execution
When you are running package in BIDS sometimes you may want to find out what is the value of SSIS Variables before or after execution of certain task. Perform the following steps.
Lets say you want to watch variable called varCustomerID before Step3 is executed.
1. Right click on Step3 Task
2. Select Edit BreakPoints
3. Check OnPreExecute option (Or OnPostExecute if you want to watch value after task is completed) and hit OK.
4. Now execute package. When breakpoint is hit you can bring variable watch window by opening “Locals” window (See below)
Check this URL for more information on various troubleshooting techniques.