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?