Getting excel filename in ssis

Question

I would like to know if there is a way I could extract the filename of my excel files to be reflected in my destination database. I'll appreciate your help in regards to this issue

Answer 1

Hello,

A Similar question has been answered here at Stack Overflow. You can either use the File Enumerator and split the result set to a variable or write a script task to get the File name.

Get File Name from Folder

---

Regards, Dinesh

Answer 2

Are you using a foreach loop to loop through the files? If so you have a variable filled with the filepath of the excel file. With an expression you can get the filename only:

RIGHT(@[User::FilePath],FINDSTRING(REVERSE(@[User::FilePath]),"\\",1) - 1)

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter