Hi, I am working on a SSIS package with the following requirements. a. I have a file watcher task and it watches C:\MFileFolder b. As soon as some one puts a file on this location it needs to pick it up and load into a database table. I am not getting a right solution for this bit. NOT able to figure out how i can pick the Excel file name Dynamically and how to configure Excel Data Connection in Such way. Have seen many Articles online that suggest usage of variables. We can set path with a Variable but how to get file NAME to concatinate with that path? Please suggest me some Article and Answer "how to get file NAME to concatinate with that path"?

Hi, check the following articles: Looping over files with the Foreach Loop SSIS: Enumerating files in a Foreach loop David.