SSIS Interview Questions Part 2

SSIS Interview Questions Part 2

SQL Server Integration Services Interview Questions Part 2

Part 1 | Part 2 | Part 3 | Part 4 | Part 5 | Part 6 | Part 7 | Part 8 | Part 9 | Part 10 

Part 2 - Question 11 to 20 out of 100 Questions

11. What is Work Flow in SSIS ?

12. What in Control Flow in SSIS ?

13. What is Data Flow in SSIS ?

14. What is difference between Control Flow and Data Flow in SSIS ?

15. What transformation available in SSIS ?

16. What is Precedence Constrain ? Why to use it ? Explain all its option ?

17. If you have 100s of task in your SSIS Package, what is the best way to create a Precedence constratint between two task ? 

18. What is Execute SQL Task ?  Why and How to use it ? Explain with a practical scenario ? 

19. In Execute SQL Task what is Result Set (Single Row, Full Result Set, XML) ?

20. If Some task is missing from your Control Flow Items, how will you bring it back ?

SQL Serve Interview Question Part 3

Part 1 | Part 2 | Part 3 | Part 4 | Part 5 | Part 6 | Part 7 | Part 8 | Part 9 | Part 10 

SSIS Personal Interview Questions

SSIS Complete Tutorial

SSIS Practical Scenarios

SSIS Tips and Tricks

0 Comments
Leave A Comment

Please login to post your valuable comments.

Join the newsletter

Get the latest vLemonn news first

share