Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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.

At design time, use the following troubleshooting features in Integration Services:

  • Package validation

  • Breakpoints and package debugging

  • Progress window

  • Data viewers in the data flow

For more information about these features, see Troubleshooting Package Development.

At run time, use the following troubleshooting features in Integration Services:

  • Package event handlers

  • Package logging, including logging of external provider messages and errors

  • Error outputs

For more information about these features, see Troubleshooting Package Execution and Working with Debug Dump Files.

For more information about SQL Server troubleshooting tools, that includes SQL Server Profiler, see Troubleshooting (Database Engine).

Integration Services icon (small) Stay Up to Date with Integration Services

For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Community Additions

ADD
Show:
© 2015 Microsoft