SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SSIS Interview Questions

I have decided to make a short series of blogs about possible interview questions to help you prepare for an interview. Last time I wrote about basic DBA questions. Today I have given you some basic SSIS question to study. These basic SSIS questions will give you a starting point on how to prepare for an interview. If you have any other suggestions feel free to add to this list but keep in mind these questions are probably for a mid to junior level BI consultant. I would assume if you're a senior BI developer you know what to expect.


SSIS Interview Questions 

1. What does a control flow do?

2. Generically explain what happens inside a data flow task? 

3. Explain what ETL is?

4. Which task would you use to copy, move or delete files?

5. Which transform would you use to split your data based on conditions you define?

6. Explain the pros and cons of deploying to a file system vs msdb?

7. If you did not know the answer to a question what would be your next step to find the answer?

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).


Posted by rashmim on 8 April 2009

Can you please provide with some more SSIS interview questions at an adavnced level?

Posted by knight_devin@hotmail.com on 8 April 2009

Sure thing I'll come up with something

Posted by sharad14587 on 5 June 2010

i want some basic SSIS interview questions

can you please provide me ?

Posted by jaiready06 on 19 March 2013


Can you please post me basic and advanced SSIS and SSRS interview questions.

Thank You

Posted by dineshvishe on 19 May 2013

What is use of data viewer ?

when uion all is used ?

Leave a Comment

Please register or log in to leave a comment.