May 16, 2009 at 1:21 am
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
Deepak Kumar Sharma
December 24, 2013 at 11:18 pm
Hi Depak,
I have post some real time basic and advance level questions and answers if you are trying to prepare yourself for SSIS interview.
http://sqlage.blogspot.com/search/label/SSIS%20INTERVIEW%20QUESTIONS
thank you
Aamir
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply