FOR Each Container in SSIS

[naga007]

Hello Mamalu i need your help to use For Each Loop in SSIS. i have 150 excel files. i need to push this data into sql server. so plz help me out....ThanX in Advance!

[recharze]

Hi
Whats the extension type of your excel files xls/xlsx?

You will be able to loop over xls files but I think you will not be able to loop over xlsx files.

refer to this link for using FELC

[url=http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx]http://www.sqlis.com/post/Looping-over-files-with-the-Foreach-Loop.aspx[/url]

[naga007]

thanks a lot for your reply, Yes my files are xls only.....even i have followed the same link to implement. but i am getting an error in the excel source. It is not showing coloumns. can you plz help me out....! i guess it is not recognizing the file dynamically

[recharze]

Send me your detailed requirement to [email protected]
May be I may help you..