Here you will find "Mixed" level SSIS Interview questions and answers.
Questions are split into 3 levels:
- For Freshers (Beginner Level),
- For Experienced (Intermediate Level - 2 to 3 years of experience) and
- Scenario based questions
SSIS Questions For Freshers
Question 1: What is the difference between Control Flow and Data Flow? [Answer]
Question 2: Name all types of containers in SSIS? [Answer]
Question 3: What is Precedence Constraint and give all available options. [Answer]
Question 4: Name all types of connections you have worked with in SSIS. [Answer]
SSIS Questions for Experienced
Question 5: What is the following SQL Server connections: OLEDB, ODBC and SQLClient? [Answer]
Question 6: Name all types of transformation you have worked with in SSIS. [Answer]
Question 7: What is the difference between Union and Merge? [Answer]
Question 8: What is the difference between Lookup and Merge Join? [Answer]
Question 9: What is a data flow buffer? [Answer]
Question 10: How can you ensure your package works when you move it to another server? [Answer]
Question 11: How can you deploy SSIS Package (or Project). [Answer]
SSIS Scenario based Questions
Visitors have asked for scenario based real life questions and we have done just that. Visit Scenario Based SSIS Questions.
We need you!
Time of free websites that are supported by ads only is over, due to increasing use of ad blocking.
Our website would die probably within a year; as there is no point investing free time and later on own money in something that is doomed.
Our only hope to survive (without any ads) is to ask our visitors like yourself to support it by becoming a member.
We know it's only going to be a tiny % of visitors who will do that but we hope that will be enough to keep our website for free and within a year switch off all ads. (54% page ads are switched off already for visitors from low income countries and 15% video ads are switched off for everyone).
Become a proud member