Hi,Karen.

Thank you very much for replying me.

I found this site : http://msdn.microsoft.com/en-us/library/ms345182.aspx

I tried Foreach Loop Container to loop one data flow which is to read, to transform, and to insert data into DB.

But this was designed only one sheet "Sheet1" s data to be inserted.

after I created a data flow task in a foreach loop container, I executed it.

it seems sheet is looped. I can see the sheet name changes after one loop is done.

But, it is inserting the same sheet's data for 3 times.

do you have any idea where else I need to change??

thank you,

tomoko