Sign In | Feedback | Donate | Search
Katie and Emil Logo
Vote Yes! I like it! [+1]  |  Vote no! Dislike? [-0]
Author: by Emil Glownia

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
  • Advanced (4 and 5 plus years of experience)

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]

Advanced SSIS Questions

We have a task to add some more advanced questions and if you have any that you think we should have or just want to "remind" us to do that than feel free to drop us a line.

Take care

Emil

Upsss... Something went wrong and Google Ads on our website did not display.

Google ads sponsor FREE content on our website and without them it would not exist.

How to fix the problem?
  1. Check if the Google Search display any ads by searching the term Business Intelligence
    • If ads don't display, try different search terms and if there no ads then there might be a problem with your browser. If you made changes to your browser behaviour then undoing them will help.
    • If ads display then, refresh our page one more time, if the problem is still there than please contact us.
  2. Become 'No Ads Learner' Member or if you are already one Sign In.
Close
Take care
Katie & Emil
Well done! It seems Google Ads display properly now on our website.

Access our website's FREE content for FREE!