Can we execute ssis package developed using VS2015 in sql server 2019 job

Prince V 1 Reputation point
2021-03-10T18:10:05.537+00:00

Can we execute ssis package developed using VS2015 in sql server 2019 job or sql server 2017 job

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Michael Taylor 60,331 Reputation points
    2021-03-10T18:26:19.9+00:00

    When you create an SSIS package you specify the version of SSIS to run against it. If you're using VS 2015 then that means you're using the unsupported SSDT for VS 2015 version. SSDT was lockstepped with the SSIS version that shipped at the same time. The older versions will target an older version of SSIS however because it interacts with SSIS via COM and newer SSIS versions ship the older COM versions your SSIS package may run just fine on the newer SSIS server if you copy them to it. You may run into issues if you try to use the designer to build and run against a newer SSIS version though. You also won't be able to take advantage of any of the newer features.

    My personal recommendation is to install Visual Studio Community or use a current version of VS 2019. Then install the SSIS extension for VS 2019. Now you can use VS 2019 to build SSIS packages that run against SQL 2017 or SQL 2019.

    1 person found this answer helpful.
    0 comments No comments

  2. Monalv-MSFT 5,926 Reputation points
    2021-03-11T03:06:27.747+00:00

    Hi @Prince V ,

    We can execute VS2015 developed ssis package in VS2017 / VS2019.

    But we should set the TargetServerVersion according to the version of SQL Server.

    76545-project-properties.png
    76561-targetserverversion.png

    Please do not post repeated questions.

    Best regards,
    Mona

    ----------

    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.

    1 person found this answer helpful.

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.