Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  Foreach Loop for Excel Worksheets

Author  Topic  AF Starting Member 7 Posts Posted - 2010-11-15 : 09:53:52 Hello all. I'm currently working on a foreach loop that will work through multiple worksheets in an excel workbook. I've followed the second set of instructions on this page - http://technet.microsoft.com/en-us/library/ms345182.aspx I've then added a dataflow task to the foreach loop and i've added an excel source to the dataflow but it won't let me select the ADO.NET connection I created when following the instructions. Any suggestions where I might have gone wrong? a.