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 2008 Forums
 SSIS and Import/Export (2008)
 Batch Excel files Import

Author  Topic 

mikebird
Aged Yak Warrior

529 Posts

Posted - 2010-03-01 : 07:36:24
How do you import multiple files (.xls) using SSIS? Is there a tool to do this? Can't find a container to loop each file into the current single file connection manager. I just keep changing the file location. There must be a simple way to batch this in SSIS? Just can't see it

Thanks
   

- Advertisement -