Introduction

SSIS is a Rapid Application Development tool that helps developers to create data transfer packages with designers and needs less coding, so that the development speed will be much faster. On the other hand, a development tool needs debugging and error-handling features. Fortunately SSIS has a debugging feature in Control Flow scope, also error handling fortified SSIS packages.

In this chapter, we will take a deep look at debugging in Control Flow and error handling in Data Flow. More event handler options will be discussed in a separate chapter later in this book.

SSIS 2012 provides some Views and Stored Procedures that monitor SSIS packages and helps SSIS administrator in some administrative tasks. This feature is one of the advantages of SSIS 2012 over its prior versions. In this chapter, we will discuss these management views.

Migrating from the earlier versions of SSIS such as 2005, 2008, and 2008R2 to 2012 is fully supported in SSIS 2012. There is a migration wizard which...