Come on people, the user needs help! there first post was:
I am new to SSIS.please help me with this"...
The link offered: http://msdn.microsoft.com/en-us/library/ms140185.aspx
Does not answer the question, and is only one part of the process.
Everyone else is not offering a true solution to the question because your just stating:
Use c# script task, for each loop, use single for look, just configure this and your set. He was new back then. When you started out did you know how to write c# as a newbie? or use for each loops?
Come on people he was new 6 years ago and I still see this happening with other forums. Offer true start to finish solutions if your going to attempt and answer a question.
I see this often where people just reply in a very smart way just do this and that, but don't offer a comprehensive answer.