Hi,
I want to loop through a number excel files in folder. I have configured the "For Each Loop" and it is working perfectly.The excel source configuration manager is giving me headache.It is either looping through a single file or giving an error when I try to adopt the procedure stated at
http://msdn.microsoft.com/en-us/library/ms345182.aspx
Please can anyone assist me with this?I have done similar thing perfect for textfiles.
Please this is urgent.
Thanks