I am facing a related error. A package was working from Visual Studio but failed while running from the SQL job.

The SSIS catalog says, "Cannot open the data file." One difference is that I'm using a flat file connection manager with a dynamics file string. So, a workaround for this kind of issue is you set a test file path into the variable and deploy the package, it will solve the error.

Thanks Abdul Majeed