Your correct about the database design but I was asked to use ssis (so the bad design continues) so any guidance on how to go about it in ssis would be helpful.

Thanks