CODEWITHSUNDEEP
ssisvisual-studio-2017sql-server-2016business-intelligence
Azhar Azmie
Azhar Azmie

Reputation: 29

Version compatibility issue in SQL Server and SSIS Packages

Currently in my machine visual studio community version 2017 version 15.9.3 has been installed and in server Microsoft SQL Server 2016 (SP1-CU3) has installed.

The issue is once I build the solution with available version and deploy it to server it gives following errors

error

even if i rebuild the ssis packages using old VS version and deploy it in server, still shows same error,

seems SSIDB keep tracking some meta data related to latest version deployment ispac. still trying to figure it out the cause for this. Initially what I want to do is using older version of VS ,need to deploy the ispac SSIS packages.

Thanks.

Upvotes: 0

Views: 6492

Answers (2)

Tab Alleman
Tab Alleman

Reputation: 31775

This is a common issue. If you build SSIS packages in VS(SSDT) 2017 and they have script components/tasks, they will not work on SQL Server 2016. Even though you set 2016 as the Target Version.

The only solution I know is to build your SSIS packages in VS(SSDT) 2015.

Upvotes: 0

PacoDePaco
PacoDePaco

Reputation: 699

I encountered similar issue while upgrading from 2008/2012 to 2017. Somehow VS is not able to upgrade .NET version, even if you do so manually, it keeps coming back to the previous one. Your problem might be related to yet another issue though, but the last message in that validation outcome you pasted actually says about invalid script version and a failure while upgrading it automatically. If you only have a few of those scripts that are causing the problem, I would copy and paste the script to a brand new script component. If you have more, what helped us was this answer.

Upvotes: 0

Related Questions