SSIS Package execution error in SQL Server

Muhammad Fawad 30 Reputation points
2023-11-15T09:45:03.0266667+00:00

I am trying to execute a deployed SSIS package from SQL Server. When I execute it, I get an error stating the picture below:

Script error.PNG

any help on this? I tried everything.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,611 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 24,011 Reputation points
    2023-11-15T15:18:53.9933333+00:00

    Hi @Muhammad Fawad,

    It seems that there is a discrepancy between SSIS Project in Visual Studio versus SSIS run-time version on the server.

    To resolve it, please make sure the SSIS Project in Visual Studio TargetServerVersion setting is matching SSIS run-time version on the server.

    Please see below.

    SSIS - TargetServerVersion_2


  2. ZoeHui-MSFT 27,466 Reputation points
    2023-11-16T02:14:07.76+00:00

    Hi @Muhammad Fawad,

    Please make sure your SSIS package in Visual Studio TargetServerVersion setting is matching your SQL Server version.

    You may need to change the version and modify your script task in case there is any incompatibility and then re-deploy the package to SQL Server.

    Regards´╝î

    Zoe Hui


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

    0 comments No comments

  3. Muhammad Fawad 30 Reputation points
    2023-11-16T04:42:48.6866667+00:00

    My SSIS is 4.4 and my SQL is 2017 version. When I Change the target version to 2017 SQL my script task gets corrupted and all the code in the script task is removed.