Hi,

I am using SQL server 2005 Integration service to load several excel
spreadsheets.

can the list of excel file names be stored in a sql server table? Then a
foreach loop container can grab each to tell excel connection manager to load
it dynamically.

some step by step tutorials would be cool.

Thanks,

Guangming