question

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

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

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

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.

cooldadtx avatar image
1 Vote"
cooldadtx answered

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.

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.

Monalv-msft avatar image
1 Vote"
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.

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
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 ·