How to set dynamic path for the excel datasource

See more:

SSIS

Hello friends,
I want to create SSIS package, which will do following
1. Import data from excel
2. There are 3 columns updateDate, Rev, Cost which will do some calculation
3. Insert data to SQL table

My Query:
1. How can set excel path dynamically, ie. we just need to dump excel in some folder and package will use that excel for further processing.
2. How can I set do calculation on Rev and Cost (ie divide it by 1000) without saving in temp table in SQL and use systemdate for updateDate column
3. How I can dump these changed value into the table

Any idea how to do this??

Thanks in advance