Friday, June 18, 2010

SSIS Interview Questions And Answers

  1. DTS vs. SSIS
  2. What is the control flow?
  3. What is a data flow?
  4. How do you do error handling in SSIS?
  5. How do you do logging in SSIS?
  6. How do you deploy SSIS packages?
  7. SSIS Connection managers
  8. How to deploy an SSIS package?
  9. How to setup a checkpoint file in SSIS?
  10. Different Options for dynamic configurations in SSIS?
  11. What is a breakpoint in SSIS? How is it setup? How do you disable it?
  12. What are variables and what is variable scope?


  1. Hi

    I like this post:

    You create good material for community.

    Please keep posting.

    Let me introduce other material that may be good for net community.

    Source: Interview questions to ask

    Best rgs

  2. hai!extreemly cool blog. u are doing an awsome work.i am also doing the same work their is copmlete and updated information on my blog and technology news as well.

  3. nice help. I also prepared some stuff on SSIS that can be found @ my blog Comments and suggestions are welcome.