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
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.