• jyoti_bhatt (6/7/2010)


    Any ideas how I can load a excel file with a dynamic filename?

    Will the folder have only one file? If so, just use a For Each Loop with *.xls or *.Xlsx Pattern, so that it picks that single file for processing.. But before that you need to prepare your DFT by properly configuring the Connection Manager...