I have visual studio 2017.
I have a script transform that I can run locally just fine, however when I deploy to the Integration Services Catalog on the dev server and run it, it fails with the following error:
'package name':Error: Failed to compiled scripts contained in the package. Open the package in the SSIS Designer and resolve the following compilation errors.
So, when I remote into the dev and rebuild the package, it will work fine on the next execution.
I thought this might be a reference issue but after reinstalling Visual studio 2017 and SSDT the references are an exact match on both machines.
What could be the issue for this?