SSIS Script transform package won't compile when deployed to dev [Visual Studio 2017]
2
votes
2
answers
2503
views
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?
Asked by Sixsmith
(23 rep)
Feb 19, 2020, 06:17 PM
Last activity: Oct 25, 2023, 02:08 AM
Last activity: Oct 25, 2023, 02:08 AM