1. How many types of containers in SSIS?
Answer: There are 4 types of containers in SSIS:
1. For Loop Container
2. For Each loop Container
3. Sequence Container
4. Task Host Container
2. Can we make our user control in SSIS?
Answer: Yes, we van make our user control in SSIS and use it in our SSIS package as depends on our needs.
We can make and register in assembly as we do in C#.
3. What are check points in SSIS?
Answer: When there are many tasks related to each other by Precedence Constraint in a package, and some error occurs during run of package then package stops and will show error. Now if we run package again then it will run from starting, but we don't want to run it from start position we just want to start it from where it was failed. For this you have to use check points in SSIS.
The CheckpointUsage property can be set to the following values:
Never
Always
IfExists