Hi there,

Thanks for posting the link http://technet.microsoft.com/en-us/library/ms345182.aspx.

However, you also wrote that we can add an Excel Source task in the Data Flow afterwards. And in the Excel Source, select the excel connection that we've already made.

I think it's incorrect. If we follow the link, the connection we create is an ADO.NET connection, not a OLE DB connection, which is what the Excel Source required.

Could you please correct that and advise what to do after the Foreach Loop is configured?

Thanks heaps.