C # disappears when deploying ssis ispac file to integration service catalog

Amit Trivedi 0 Reputation points
2024-01-24T15:57:41.3066667+00:00

I have developed a ssis package in VS 2019. The package has script task in it, written in VS C# 2019. The problem is when I deploy the package using .ispac file into the integration service catalog. All code in the script task disappers.

Intrestingly, when I deploy the package into same integration service catalog directly using visual studio then the package works fine and the script task code persists.

Here is how I deploy the ispac file: a) Double click the ispac file, click on next b) Select the ispac file using 'Select Project Deployment file' option and click next. c) Provide the target server name and browse the folder in integration catalog. d) Click Next and Finish Note: The version of sql server is 2019 and when I deploy the package using both ways, I change the TargetServerVersion property to 2019. I am stuck in this strange problem. Please help.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,472 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,644 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 26,376 Reputation points
    2024-01-24T18:18:04.82+00:00

    Hi @Amit Trivedi,

    The version of sql server is 2019 and when I deploy the package using both ways, I change the TargetServerVersion property to 2019.

    You need to set TargetServerVersion property to SQL Server 2019 at the very beginning of the development in VS2019, not at the end, just before the deployment.


    Please try to do deployment the following way:

    1. Using SSMS (It is better to use version 18 or 19) and connect to the SSIS run-time instance of SQL Server.
    2. Navigate to: "Integration [Services Catalogs] => ... => [Projects].
    3. Right mouse click, select [Deploy Project...].
    4. Select [Project deployment file], specify Path to the .ispac file, and follow the wizard.
    1 person found this answer helpful.
    0 comments No comments

  2. ZoeHui-MSFT 40,511 Reputation points
    2024-01-25T01:41:21.0833333+00:00

    Hi @Amit Trivedi,

    There is a known issue that has been fix here.

    • Bug fix
      1. Fixed a bug that a package, containing script task or script component and belonging to a project imported from an ISPAC targeting old SQL, failed to execute.
      You may download the SSIS project v4.5 to solve the issue. Regards, Zoe Hui

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

    0 comments No comments

Your answer

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