Resolved the issue!

1. Declared another variable

2. Add script task

3. Passed Excel file name as read only and new variable for readwrite.

4. Updated new variable value by replacing xls...

Thanks for replies!

Let me share the development.

Now I am able to successfully read the excel file (having same structure in same folder)...

Now the final objective is remaining!

The Destination connection is...

Yes, the source excel files are of same structure!

Could you plz explain more in detail HOW TO SET EXCEL CONNECTION USING EXPRESSION?

Thanks

Hi ALL,

Let me share my work:

Successfully upload data in SQL from multiple CSV files and saved on different location.

Now I want to convert excel file(s) into CSV file if exists...

details:

Excel files exist at C:\MyData1. FileOne.xls

2. FileTwo.xls

3. FileThree.xls

Need to export all excel files data in CSV files:

1. FileOne.csv

2. FileTwo.csv

3. FileThree.csv

Well! following are my requiremetns:

1. If file file format is xls then

1.1 convert XLS file into CSV format

...

One more querstion on thsi:

Now the result is as follow:

1.10%

2.00%

10.00%

12.00%

Is it possible to implement some formatting on that values like:

1.10% = 01.10%

2.00% = 02.00%

10.00% = 10.00%

12.00% = 12.00%

Thanks

Thanks Gail!

Its perfect.

Well I am expecting result in following order:

1.10%

2.00%

10.00%

12.00%