Data Warehouse [SSIS] Questions: Notes: What are Non-Blocking Transformations? Non-blocking Transformations are transformations that work with only individual field values for rows in the pipeline, they can transform the data row by row. A transformation with this requirement can begin to process data as it flows to it and will make processed rows available down […]
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 […]
