Execute SQL Task vs OLEDB Command Transformation
Execute SQL Task:
Comes under Control flow
Batch Operation
OLEDB Command Transformation:
Comes under Data Flow
Row by Row Operation
What is SSIS Container? Explain Different types of Containers in SSIS
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...
Comments
Post a Comment