• Actually, if you do what anyone going on an interview should do for these types of doubts is show just a little prowess with Google. Search for "SSIS architecture" and be amazed. I would expect any and every candidate to be able to find the answers to these types of questions. It's just not that difficult. All you have to do is try.

    Similar MS documentation is also available in Books Online. Lookup "SSIS" in BOL and then scroll down 4 lines and click on the word "Architecture".

    I'd also expect a candidate to be proficient in being able to use Books Online.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)