SSIS excel Generate Error

I am a beginner to SSIS. i have been facing some issues with generating excel using the SSIS. I package generate 10 excel reports in parallel.Excel is generated using a pre formatted excel, and the package copy that template to a given location and the excel is generated on the destination path.The package is called from parent package.That parent package is called using the SQL JOB.Now the problem is when i am executing the package,i am facing some challenges.all the reports are generating but sometimes the generation fails.the failure doesn't happens for all the reports one or two excel file generate fails.

Description: "External table is not in the expected format.". End Error Error: 2017-01-11 22:53:06.32 Code: 0xC020801C Source: Loan Insource Data Excel Destination [73] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Loan Insrc Data1" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2017-01-11 22:53:06.40 Code: 0xC004701A Source: Loan Insource Data SSIS.Pipeline Description: component "Excel Destination" (73) failed the pre-execute phase and returned error code 0xC020801C. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 22:36:15 Finished: 22:57:22 Elapsed: 1267.15 seconds. The package execution failed. The step failed.

This is classic error come while working with Excel data sources.

To solve

Step 1: Navigate to Project-> [PROJECT_NAME] Properties.

Step 2: Navigate to “Debugging” option from left panel and from Right panel change Run64BitRuntime value to false.