How to debug/Troubleshoot an SSIS Package

In this video you will learn how to debug an SSIS Package that failed in Production. This video was made to answer SQL Server Integration Services interview question " How to debug your an SSIS Package".

The video explains how following items can help to debug/troubleshoot an SSIS Package

  • Data Viewer
  • BreakPoints
  • Logging 
  • Email Notification
  • SQL Server Job history

Debug an SSIS Package