Data Warehouse [SSIS] Questions: Notes: What are Asynchronous Components? The output of an asynchronous component uses a new buffer. It’s not possible to reuse the input buffer because an asynchronous component can have more or less output records than input records. The only thing you need to remember is that synchronous components reuse buffers […]
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 […]
