Apologies... really got hammered by work-work.
Are you all set now?
Just as a bit of a sidebar, this is also pretty easy using only T-SQL. If you'd rather do that than work this problem in SSIS, let us know.
--Jeff Moden
Change is inevitable... Change for the better is not.