While trying to run one of our SSIS Packages from SQL Server Job, which had script component in it, we got the below error. It was running fine within the SSDT in our Dev Machine. In fact, the other packages deployed to SSISDB were also running fine, the ones which were not using the Script Component.
To fix it, we updated the project version of SSDT to match the SQL Server where we were deploying the package inside Project Properties.
To find the SQL Server version.
And deployed
only…
