Hi guys,

I have many excel files in the folder. I want to insert the data of all these files into tables with the excel files name.

I create a package with Foreach loop container with data flow tsk into it with varibles defininf the files name.

Variables:

Name : FileName

Scope : Package

Datatype : String.

Value : E:\Farooq\SSIS data Sources ( In this folder there are multiple excel files)

I added derived column task to the flow and in the derived column, i used this varible but i'm not getting proper result and it is throwing error.

Added to this, I configured the excel expression properties as

Excel File Path : @User::FileName

I'm not getting the desired result.

Please help me on this.