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 of Flat File...

I would Like to save the excel file with the same name like 'MyData1.xls, MyData2.xls,.. etc) as

(MyData1.csv, MyData2.csv,... etc)

I am trying to replace Xls with CSV in expression of Destination file connection:

REPLACE(@[User::varExcelFile] , "XLS", "CSV" )

PS: varExcelFile variable has the full path including name & extension of excel file!

For temporary purpose I placed a CSV file name + location in DestinationConneciton.

DelayValidation = True

Result on Execution:

The processing of file "C:\MyData1.xls" has started.

The process cannot access the file because it is being used by another process.

Cannot open the datafile "C:\MyData1.xls".

failed the pre-execute phase and returned error code 0xC020200E.

The processing of file "C:\MyData1.xls" has ended.

wrote 0 rows

Task failed:

Warning: 0x80019002 at Foreach Loop Container: The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

SSIS package "FileConversion.dtsx" finished: Failure.

I then Set Max Error Count = 0 then

all error msgs a mention earlier except Max Error Count.

Any Tip/suggestion?