What is an event handler? It is a workflow that responds programmatically to events that occur on a package level, container level, task level or change of variable value What is MSDTC? The built-in transaction support in SSIS makes use of the Distributed Transaction Coordinator (MSDTC) service which must be running for the transaction to […]
What is the difference between Fuzzy Lookup and Fuzzy Grouping? Fuzzy Lookup is used to find clean data. Fuzzy Grouping is used to remove duplicate data. Fuzzy Lookup works on a row by row basis. Fuzzy Grouping works on rows within a group. Fuzzy Lookup uses a clean reference source as well as its input. […]
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 […]