Can we execute VS2015 developed ssis package in VS2017 / VS2019

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

I have number of packages developed using visual studio 2015. Most of the packages uses script task. Can I execute these packages using VS2017 or VS2019 without making any changes to the packages manually. And then can I set deployment target version as sql server 2019 to execute via sql server 2019 jobs.

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Monalv-MSFT 5,891 Reputation points
    2021-03-11T02:10:43.71+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.
    76457-project-properties.png
    76458-targetserverversion.png

    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.