Smash125 (9/21/2012)
Its been while have not given any interview SSIS.Just preparing my future course of actionOne common questions that comes to my mind is
Explain SSIS architecture? My answer may differ from others answer. What Suggestion would you give or what should be the approach.
I'd explain the role of SSIS and how it fits into a typical ETL. From there, I'd ask the interviewer specifically what more they want to know.
MS has some info at: http://technet.microsoft.com/en-us/library/ms141709(v=SQL.90).aspx
HTH,
Rob