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

Protection level: Securing sensitive data

Packages are XML files; all Control Flow and Data Flow settings, every task and component are listed in the XML file. So accessing this file needs to be considered before deployment.

SSIS provides a way to protect information stored in packages with encryption. There are a number of options for how that encryption can be opened. Packages contain two types of data: data related to structure of data transfer, like Data Flow components or Control Flow tasks, and connection string passwords or any other information that is very important and shouldn't be easy to access; this information is called sensitive data.

There are a number of protection levels to protect a package's information. In this recipe, we will ...

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