I was looking for an answer to this but I didn't see it, now that I have an answer this is what I did for dynamically adding new columns. Since my data is created new each day I just added an execute SQL task and dropped and recreated the table from the data source. Ensuring that I used a SELECT into.
Example:
drop table [yourtable]
select * into [yourtable] from [otherdb].[dbo].[servertable]