O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13. Restartability and Robustness

by Reza Rad

In this chapter, we will cover the following topics:

  • Parameters: Passing values to package from outside
  • Package configuration: Legacy method to inter-relation
  • Transactions: Doing multiple operations atomic
  • Checkpoints: The power of restartability
  • SSIS reports and catalog views

Introduction

Data transfer packages should be robust in design. There are times that a package can get values from outside and set some ETL parts based on input variable. You learned how to create dynamic SSIS packages in the previous chapters, but to run a package dynamically, you may need to pass some values from outside of the package. Package parameters provide a way to get values from outside of the package. With changing ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required