Share via

Programmaticaly recompile script tasks/components not working when SQL Server 2019 CU15 is installed

Patrick Rühmkorb 1 Reputation point
2022-02-08T15:17:18.797+00:00

We are using an deployment process that clones the SSIS projects from Git and uses a Script Task to recompile all the script components and script tasks that are included in the SSIS packages (we've got over 1000 packages and are still developing new ones). At the moment we are using SQL Server 2017 for Integration services but want to migrate to 2019. While preparing the migration I encountered a strange problem: the script task that recompiles all scripts is working on several different machines but it's not working on the server that was already patched with CU15.
After running the script task all packages are missing the binary code of the script tasks/components.
My local machine has no updates, on other machines there is the CU14 version. When running on these machines all the packages contain the binary code.

Is this a bug of the CU15 patch?

Is it possible to include the older references of the different dlls I need to recompile the scripts?

SQL Server Integration Services

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,551 Reputation points
    2022-02-09T08:11:46.253+00:00

    Hi @Patrick Rühmkorb ,

    We could not ensure if this is a known issue for CU15.

    For the environment is different that we could not re-produce the issue.

    I recommend you to submit your issue to the Microsoft feedback at this link https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0 .

    This site will serve as a connecting point between you and Microsoft, and ultimately the large community for you and Microsoft to interact with. Your feedback enables Microsoft to offer the best software and deliver superior services, meanwhile you can learn more about and contribute to the exciting projects on Microsoft feedback.

    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.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.