title: LOGIC to retrieve the folder name from the file path in ssis
body: <p>I've run into an issue while developing a new package for automating the loading of data from Excel files into a database table. While loading I need to extract the FOLDER NAME in which the Excel file is located, basing on the name of the folder I have to retrieve some other information to be loaded  in database. I need help with the LOGIC to retrieve the folder name from the file path.</p>