How to do Performance Tuning a SSIS package? or How to troubleshoot a SSIS package?

Sometimes it may happen we are doing required trouble shooting to a SSIS package when it fails. But when we are at interview we cann't remember all the trouble shooting procedures we have done. So here I am hilighting all troubleshooting procedures only at high level , not drill down into detail level

Troubleshooting Package Development

Troubleshooting Design-time Validation Issues

 Work Offline when data sources are not available
 Configure the Delay Validation property on package elements that are not valid until run time
Troubleshooting Control Flow

 Set breakpoints on tasks, containers, and the package
 Use the debugging windows
 Review the information on the Progress tab

Troubleshooting Data Flow

 Test with only a subset of your data
 Use data viewers to monitor data as it moves through the data flow
 Configure error outputs on data flow components that support them
 Capture the count of rows processed
 Review the information on the Progress tab

Troubleshooting Scripts

• Set breakpoints in script in Script tasks
Troubleshooting Errors without a Description

Troubleshooting Package Execution

Catching and Handling Package Errors by Using Event Handlers
• Create an event handler for the On Error event
Troubleshooting Bad Data by Using Error Outputs
• Capture bad data by using error outputs
• Add friendly information to the error outputs
• Add the description of the error
• Add the name of the error column

Troubleshooting Package Execution by Using Logging

 Enable logging
 Select the package's Diagnostic event to troubleshoot provider issues
 Enhance the default logging output
1. Create a parent table that logs each execution of a package
2. Add auditing information to the data flow
3. Consider capturing row count data

Troubleshooting Package Execution by Using Debug Dump Files

Troubleshooting Run-time Validation Issues

Troubleshooting Run-time Permissions Issues

Troubleshooting 64-bit Issues

Troubleshooting the Integration Services Service

Troubleshooting Service Startup

Verify the startup type of the service

Troubleshooting Service Permissions

Finally Working with Debug Dump Files

Thanks,