naga007 Posted September 4, 2010 Report Share Posted September 4, 2010 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! Quote Link to comment Share on other sites More sharing options...
recharze Posted September 4, 2010 Report Share Posted September 4, 2010 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] Quote Link to comment Share on other sites More sharing options...
naga007 Posted September 5, 2010 Author Report Share Posted September 5, 2010 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 Quote Link to comment Share on other sites More sharing options...
recharze Posted September 5, 2010 Report Share Posted September 5, 2010 Send me your detailed requirement to [email protected]May be I may help you.. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.