Blog

  • Home
  • SSIS
  • Error and Event Handling In SSIS

Error and Event Handling In SSIS

  • (4.0)
  • | 721 Ratings |
  • Last Updated April 21, 2017

What’s In This Topic?

  • Working with precedence constraints
  • Creating failure flows with expressions
  • Defining SSIS events
  • Handling events in a package
  • Troubleshooting with breakpoints and logging
Learn how to use SSIS, from beginner basics to advanced techniques. Enroll for Free SSIS Training Demo!

SQL Server Integration Services provides some valuable features that enable you to control the workflow of your SSIS packages at a very granular level. Functionality that you might expect to be available only by scripting can often be accomplished by setting a few properties of a component. In addition, SSIS comes with powerful error-handling capabilities, the capability to log detailed information as the package runs, and debugging functionality that speeds up troubleshooting and design.

This Topic walks you through controlling the package workflow, beginning at the highest level using precedence constraints and then drilling down to event handling. You’ll see how trappable events play a role in breakpoints, and how to perform exception handling for incorrect data in the Data Flow. Finally, you learn how these features can be used for troubleshooting, debugging, and building robust SSIS packages.

 

Frequently Asked SSIS Interview Questions & Answers

 

List of Related Microsoft Certification Courses:

 SSRS  Power BI
 SSAS  SQL Server
 SCCM  SQL Server DBA
 SharePoint  BizTalk Server
 Team Foundation Server  BizTalk Server Administrator

 

Subscribe For Free Demo

Free Demo for Corporate & Online Trainings.

Free Demo Popup -->