I think you may have posted this question in the wrong forum. But in answer to your question you'd have to open the package so the metadata refreshes for any additional columns to be added to the other data flow tasks. This is probably the most simplest
Proposed As Answer byZilong LuWednesday, October 26, 2011 3:24 AM
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.