SSIS interview questions

1)difference between control flow and data flow?

2)logging in ssis?

3)how can we use check points in SSIS packages?

4)what is transaction concept in SSIS?

5)Error Handling in ssis?

6)how can we deploy the packages in SSIS?

7)in how many ways we can run the packages in SSIS?

8)what are all the command line tools available in SSIS?

 9)How do you schedule ssis packages ?

10)how do we run the stored procedures in SSIS?

11)explain SCD and its types?

12)Difference between SSIS and DTS?

13)Have you used SSIS Framework?

14)What configuration options have you used?

15)How to quickly load data into sql server table?

16)What is XMLify component?

17) You would like to log all the package errors to a custom database table you have created for auditing purposes. How can you accomplish this task?

18) Explain architecture of SSIS?

19) What is Execution Tree?

20) Difference between Unionall and Merge Join?