A package with a Script Component that runs fine on SSDT (Visual Studio 2017) does not run when deployed to SQL Server 2016. It throws a ComponentVersionMismatchException.
So, other packages work fine. This one has a data flow with a Script Component destination. When I first started developing the project, I hadn't adjusted the target from SQL 2017 down to SQL 2016. I developed everything and got it to run from SSDT. I'm using a .ispac file to deploy. When deployed, it's throwing the ComponentVersionMismatchException. Here's what I've tried to get a script component to run:
I would expect that a brand new project targeting SQL 2016 with a script component that does nothing should be able to execute on the server. I'm rather lost at this point.
Given what Piotr said AND that I had already updated to the latest version of the VS shell/SSDT for VS2017, I tried installing SQL Server Data Tools for VS2015.
Visual Studio 2015 was able to deploy directly to the (local) server and the packages deployed from the VS2015 version did not exhibit the execution issues that the ones from VS2017 did.
Given that SSDT for VS2019 has been released, it might be worth trying that version out in the future.
Looks like it is a still unfixed bug in SSDT for VS2017.