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 talk about protection levels and how to use them and their differences.
How to do it...
Open R03_Package Deployment Model project in SSDT.
Open
P02_Child.dtsx
, click on an empty area in Control Flow, then go to the File menu and then Save Copy of Package...