Explain Union all Transformation?

 It works in the opposite way to merge transformation. It can take the output from more than 2 input paths and combines into a single output path.

Comments

Post a Comment

Popular posts from this blog

What is SSIS Container? Explain Different types of Containers in SSIS

Image
SSIS containers are defined as a set of logically linked tasks that allows the management of the task scope effectively. Containers allow looping through tasks set until tasks are grouped logically or until specified criteria are met. Nesting of containers is also allowed and the containers are set in the Package designer section in the Control flow tab.   The following containers are present in SSIS: Task Host Containers:  Default container where all single tasks are available and are used for background scenes in SSIS. This is not present in the toolbox of Visual Studio and is assigned to the task implicitly. This container is also used to extend event handlers and variables. Sequence Containers:  These handle the flow of package subset and helps to divide packages into smaller pieces. These are displayed in the Control Flow tab. We can drag and drop containers from the toolbox in the design pane and then add a set of tasks into the container. Following things can be ac...
Read more

What are import and export column transformations?

Import Column Transformation  – The Import Column transformation reads data from files and adds the data to columns in a data flow. Using this transformation, a package can add text and images stored in separate files to a data flow. * Export Column Transformation  – The Export Column transformation reads data in a data flow and inserts the data into a file. *
Read more

How checkpoint works in for loop?

  For each Loop, the container is another atomic unit of work that can be restarted. However, the checkpoint file does not contain information about the work completed by the child containers, and the for each Loop container and its child containers run again when the package restarts.
Read more