Share via

SSIS Package execution error in SQL Server

Muhammad Fawad 55 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.
13,827 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 25,861 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 36,661 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
  3. Muhammad Fawad 55 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.

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.