Deloitte interview question

SSIS Concepts and SQL scenarios. Strength and weakness