Data Warehouse [SSIS] Questions: Notes: What is Required? Required is where the container starts a new transaction. If an existing transaction has already been started by the parent container, the container will join it. What is Data Blocking? Data Blocking is where data in the pipeline is held up by a transformation operation. It blocks […]
Data Warehouse [SSIS] Questions: Notes: How do you apply configurations to a package? Use a package configuration to override selected property values stored in a separate file or configuration resource. Typically, this is used to apply properties, such as file paths or connection strings, that would need to be changed when the package is moved […]
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 […]