SSIS:
1)  how to import multiple files  in SQl server?
2)  what is mean by  delay validation?
3)  what is mean by derived column?
4)  what is mean by conditional split?
5)  explain error handling in SSIS?
6)   explain different ways  to Deploy SSIS Pacakge?

SQL:
1)  explain joins?
2)  explain temporary tables,  CTE and table variables?
3)  difference between temporary tables,  CTE and table variables?
4)   what are different types of indexes?
5)  explain nolock in SQL server?
6)  what will be the output of the below query:
SELECT * INTO Table A FROM Table B Where 0=1;
7)  explain  error handling in SQL server
8)  in try catch block how to execute 2nd query,  when 1st query fail?
9)  explain query execution plan
10)  what is mean by Performance tuning?
11)  In vs Exists?

12)  difference between ROW_NUMBER(), RANK(), DENSE_RANK()