Conditional Split in SSIS
Conditional Split in SSIS
This transformation lets you route your data flow to different outputs, based on criteria defined within the transformation’s editor.
What is default value of DelayValidation property in SSIS
The default value of DelayValidation property in SSIS is false
What does DelayValidation property mean in SSIS
DelayValidation Property
DelayValidation property indicates whether validation of the task is delayed until run time.
What are different task colour shown when SSIS package exceutes ? What each colour mean ?
Different task colours shown on task during SSIS package execution are :
- Yellow – means task is executing
- Green – means task has executed successfully
- Red – means task has failed
What are various tabs in SSIS Package Design window ?
Various tabs in SSIS Package Design window :
- Control Flow
- Data Flow
- Event Handlers
- Package Explorer
SSIS : What is difference between Control Flow and Data Flow in SSIS ?
Difference between Control Flow and Data Flow in SSIS are as follows :
- The smallest unit in Control Flow is task whereas smallest unit in Data Flow is component
- In Control FLow , Tasks require completion (success, failure or completion) before moving to next task. In Data Flow , one component will not wait for other component to finish, all of them will work together in processing and managing data in streaming way.