I am facing a strange issue on SQL Server 2017 Enterprise edition running in AWS on EC2.
When we are on the SQL server and we import an SSIS package using the locally installed SSMS connected to Integration Services it is successful. But, the package fails to run with an error:
The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully.
However, if we perform the exact same procedure from a remotely connected Windows 10 PC using the SSMS that is installed on the PC, the package will run properly.
Both the server and the Windows workstation are running SSMS 17.9.1. Comparing versions in Help -> About shows the exact same version numbers on everything. The same domain user is performing the procedure and that user is a domain admin and SQL Sysadmin.
This makes no sense. Is there another component being used I am unaware of? Any ideas?