This is a good article, and your explanation as to why you did this in SSIS is a great example of how "best" practices sometimes are NOT the best solution for a particular business need.

hr_sn, I expect we'll see your article on how to do this in T-SQL soon? 😛