question

EricvanderVoort-1276 avatar image
0 Votes"
EricvanderVoort-1276 asked ZoeHui-MSFT answered

Packages builds and executes correctly in VS2019 but fails when deployed to SSISDB

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

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @EricvanderVoort-1276,

Please help check:

Make sure that the TargetServerVersion is 2017.

Open script Task and build the project.

Redeploy SSIS project to the SQL Server 2017 for a try.

Also refer the-binary-code-for-the-script-is-not-found-vs2019.html to see if it could be useful.

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.