Data Warehouse [SSIS] Questions: Notes: What are the properties of Package Password Protection? All of the security options are controlled by the protectionLevel property. With the package open in the package designer, you can use the Properties window to set the ProtectionLevel property to one of the following values: DontSaveSensitive Removes passwords and other sensitive […]
Data Warehouse [SSIS] Questions: Notes: What is the difference between running a package in the SSIS development platform and in a production server? The package designer and development platform does a good job of emulating true package execution, but it isn’t the same for at least two reasons. In the designer, a package runs with […]
Data Warehouse [SSIS] Questions: Notes: Can you create a Differential Backup with an existing Full Backup? You use a differential backup along with a full backup. If a full backup does not exist, you cannot create a Differential Backup. As with a full backup, you can perform a differential backup of a database no […]
Data Warehouse [SSIS] Questions: Notes: What are the types of Control Flow Elements? There are 3 different types of control flow elements in SSIS. There are containers, tasks, and precedence constraints. These all have different uses in the control flow. What are Containers? Containers are used to give structure to packages. There are 3 container […]