SSDT 2017 - TargetServerVersion issue with SQL Server 2019
Hi All,
I have a computer on which I installed SSDT 2017 (standalone installer) 2-3 years ago.
Offical MS site claims that Supported SQL Versions for SSDT 2017 are "SQL Server 2012 - SQL Server 2019".
I can develop, deploy and run SSIS packages targeting SQL Server 2017 and also SQL Server 2019 successfuly on this machine.
In "About" window I can see these details:
SSDT Version 15.9.43
SQL Server Data Tools 15.1.62002.01090
SQL Server Integration Services 15.0.2000.170
Microsoft SQL Server Integration Services Designer Version 15.0.2000.170
In "Extensions and Updates" window it also lists "Microsoft Integration Services Projects 2.11".
Problems start here.
Recently I got a new machine and I executed SSDT 2017 stanadlone installer on this one.
However I can't select for TargetServerVersion SQL Server 2019, the latest available option is SQL Server 2017.
In "About" window I can see these details:
SSDT Version 15.9.75
SQL Server Data Tools 15.1.62002.01090
SQL Server Integration Services (empty - no version number!)
Microsoft SQL Server Integration Services Designer Version 14.0.3002.113
In "Extensions and Updates" window it also lists "Microsoft Integration Services Projects 1.6".
A clear difference is visible under this path:
"C:\Program Files (x86)\Microsoft Visual Studio\2017\SQL\Common7\IDE\CommonExtensions\Microsoft\SSIS"
On the old machine I have a 140 and also a 150 folder, but on the new one I can see only the 140 folder.
It seems that SSIS and designer version are differ but I can't find any resources to update it.
On Visual Studio Marketplace I have found "SQL Server Integration Services Projects" extension, but it is available only for VS2019.
Can you help me please with some recommendations to resolve this issue?
Thanks in advance!