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

Basic 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).


No comments.

Leave a Comment

Please register or log in to leave a comment.