• 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 with CSV

    5. In flat file connection property used new variabel in expression for connection string.

    6. In ForEach loop placed script task and on success called data flow.