SSIS:
  1. Project Details and Daily Activity
  2. How much You will rate yourself for SQL, SSRS and SSIS Out of 5?
  3. How many packages have you created?
  4.  Which types of Sources are you currently using?
  5. How many jobs have you created?
  6. How to handle error handling in SSIS?
  7. What is checkpoint?
  8. How to set email notification for job failure?
  9. What is multicast transformation?
  10.  What is delay validation?
  11.  What is meant by retain same connection?
  12.  What is SSIS configuration?
  13.  How many types of configurations?
  14.  How to deploy SSIS packages?
  15.  How to deploy packages using command line?
  16.  How to create a job?
  17.  Suppose 10 packages are there, how to schedule them one by one?
  18. How to do above at job level?
  19.  what is merge transformation?
  20.  what is left join?  how many joins are available in merge transformation?
  21.  how to upgrade SSIS packages?
  22.  what is the basic configuration of SSIS?
  23. What are the different elements of control flow in SSIS?
  24. What is command line tool we can use to execute SSIS package?
  25.  identity in SQL
SSRS:

  1. What is report life cycle?
  2. How many reports have you created?
  3.  which types of report you have created?
  4.  how many types of subscriptions are available in ssrs?
  5.  Suppose I have 50 branches,  I have to send a report to each branch agent.  How will you do this?
  6. If user wants to access that report how will you provide security to report?