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

Answers To SSIS Interview Questions

This is just a starting point for you to prepare for your interview so make sure not to limit yourself to what you find here. These answers could easily vary but generally someone who is interviewing is looking not only for a correct answer but confidence in your answer. If you have any questions about my answers or have something to add feel free to do so, but I did try to keep the answers short and sweet.  

SSIS Interview Questions 

1. What does a control flow do?


A control flow manages the workflow of the package. Pretty self-explanatory it controls the flow of how the package is run. Sorry to use the words control flow in the definition, but this is a real easy one.

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

It moves data from nearly any source, performs different transforms to the data, then sends to nearly any destination.

3. Explain what ETL is?


Extract, Transform, and Load. Basically pulls the data from a location, change/transforms the data somehow, and then loads it in a new location.

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


File System Task (This is just an example know all control flow tasks)

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


Conditional Split (This is just an example know all data flow transforms)

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


Functionality               Best in File System                Best in MSDB
Security                                                                                X
Backup and Recovery                 X
Deployment                                X
Troubleshooting                         X
Execution Speed                         X                                       X
Availability                                  X

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


Search online, read a book, or ask for help. I generally would suggest it in this order.


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 sandhyamurukutla on 28 September 2010

hi i am new to this site .i want to ask onething .can u send me the questions based on project related to products&sales

Leave a Comment

Please register or log in to leave a comment.