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 […]
Data Warehouse [SSIS] Questions: Notes: What are Merge Join Transformations? The Merge Join transformation will give an output by taking two inputs and performing an INNER, LEFT, or FULL OUTER JOIN on the two tables. The input data must be sorted according to the matching columns for this to work correctly. We can then derive […]