• I would talk about differing philosophies of the role of SSIS. Some people love it and want to do everything in SSIS, while others use it as a framework for executing stored procedures.

    You could mention whether you like lots of small packages controlled by a master, or if you like one big package. You can talk about whether you have worked with a package framework using shared logging and error handling etc.

    Personally I like to do as little as possible in SSIS because I find it much easier to read sql than to infer logic by clicking on objects, however, I have begrudgingly acknowledged that SSIS lookups can be faster than SQL updates when assigning multiple surrogate keys to large volumes of data.