Share via

What are the Software requirements for executing SSIS scriptask with SQL server 2019 as target DB

Prince V 1 Reputation point
2021-05-12T04:33:06.01+00:00

Hi Team

I have developed SSIS package(with script task) using visual studio 2015 (SSDT 2015). But I am getting error while executing it using SQL Server 2019 sql agent job. I want to know what are the prerequisites for successful execution. This package is working fine in one server but failing in another server. I am using xml configuration file and file deployment method. Please let me know the correct version of softwares required for executing ssis package in 2019 SQL server job.

  1. Visual studio version
  2. SSDT version
  3. Dotnet version
  4. Any other softwares needed (e.g: visual c++) or any other settings needed.
  5. what version of sql server 2019 to use. Latest patch update needed or not.
  6. script task version(if any) If someone can provide the correct link to download these softwares it will be very helpful.

Thanks in advance
Prince

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,704 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Prince V 1 Reputation point
    2021-05-12T11:55:01.107+00:00

    Hi .. please find the screen-shot. This error is not coming in other server.. I want only the details of correct 95910-screenshot-20210512-171324-whatsapp.jpgsoftwares version required .. for e.g. dotnet version cannot be less than 4.7 for sql server 2019.. etc.,

    0 comments
  2. Yitzhak Khabinsky 26,586 Reputation points
    2021-05-12T12:28:18.947+00:00

    HI @Prince V ,

    You need to compare one particular setting: TargetServerVersion

    • on a development workstation in Visual Studio (VS)
      vs.
    • SQLServer/SSIS run-time environment on a server.

    Please see below how it looks like in VS.

    96031-ssis-targetserverversion-2.png

    0 comments
  3. ZoeHui-MSFT 41,491 Reputation points
    2021-05-14T07:43:41.2+00:00

    HI @Prince V ,

    SSIS versions are not backwards compatible.

    If you want to executing SSIS scrip task with SQL server 2019, you may use VS2019.

    download-sql-server-data-tools-ssdt

    SQL Server Integration Services Projects

    Regards，

    Zoe

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

    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.
    Hot issues October

    0 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.