Home Forums SQL Server 2005 SQL Server 2005 Integration Services Use Database table to dynamically get the excel filename RE: Use Database table to dynamically get the excel filename
Mukti
SSCrazy
Points: 2826
More actions
September 10, 2008 at 3:45 pm
#870005
Excel connection has the ExcelFilePath that you can set dynamically. (Edited by previous answer too).
Use the File Enumerator in ForEach loop.