When I deploy a package to SSISDB after it has been successfully tested and executed in VS2019 Studio. it won't run in SSISDB.
When validated it returns the error:
myPackage: Error: "Script Component" failed validation and returned validation status "VS_ISBROKEN".
myPackage: 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.
When checked again in VS2019 it builds correctly, no error there and it returns records when executed.
How to resolve the error in SSISDB and make it work successfully.
Visual Studio 2019 16.10.2
SSIS Integration Services 3.14
SQL Server 2017 Standard Edition RTM-CU24