You might encounter this problem, while you debug or execute the SSIS package in SQL Server Business Intelligence Development Studio.
No need to worry first of all, it is a simple fix!
Firstly, while you debug, change the Run64BitRuntime property to False in the SSIS Property Pages. Click Ok and try executing the script.
But you may again encounter, the error message, while you add this SSIS as a Job in the SQL Server Agent. The process to fix the problem is mentioned below.