Troubleshooting Tools (Integration Services)
Integration Services does not include any stand-alone troubleshooting tools. However, Integration Services provides many valuable features that you can use to troubleshoot packages at both design time and run time.
Design Time Troubleshooting Features
At design time, use the following troubleshooting features in Integration Services:
Breakpoints and package debugging
Data viewers in the data flow
For more information about these features, see Troubleshooting Package Development.
Run Time Troubleshooting Features
At run time, use the following troubleshooting features in Integration Services:
Package event handlers
Package logging, including logging of external provider messages and errors
SQL Server Troubleshooting Tools
For more information about SQL Server troubleshooting tools, that includes SQL Server Profiler, see Troubleshooting (Database Engine).