question

PrinceV-3211 avatar image
0 Votes"
PrinceV-3211 asked Monalv-msft edited

Can we execute VS2015 developed ssis package in VS2017 / VS2019

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
0 Votes"
Monalv-msft answered Monalv-msft edited

Hi @PrinceV-3211 ,

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.




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @PrinceV-3211 ,

May I know if you have anything to update?

Best regards,
Mona

0 Votes 0 ·