Download Xml Files: Cannot load script for execution

Question

I'm executing an SSIS package from Integration Services Catalogs under SSISDB. It's getting this error on a script task. I rebuilt the task.
SQL Server 2019
Visual Studio 2019
TargetServerVersion SQL Server 2017
Download Xml Files: Cannot load script for execution

Answer 1

SQL Server 2019 ... TargetServerVersion SQL Server 2017

For SSIS it is important, than the version of SSIS and package TargetServerVersion matches.
Does the package work when you run it in SSDT?

Answer 2

Hi @Thirston Third ,

VS2019 is not using SSDT anymore. It needs SQL Server Integration Services Projects extension.

If your SSIS run-time version on the server is 2019, you need to set TargetServerVersion='SQL Server 2019' in the VS2019 project settings.

Answer 3

Hi @Thirston Third ,

Change the TargetServerVersion to SQL Server 2019 and then rebuild the script task.

Remember to save the package and re-deploy it.

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.