VS2019
1 TopicVS2019 with SSIS extension 4.5 crashes when setting target version to SQL Server 2016
After completely re-installing VS2019 and SSIS extension 4.5 I'm not able to develop an SSIS package in which I set the TargetServerVersion to SQL Server 2016. If I create a new SSIS package then as long as the SQL target version is 2017 or higher then everything is working perfectly. However if I create a new empty SSIS package then as soon as I change the SQL target version to 2016 VS2019 crashes with the exception as shown below. What I observe is that as soon as I change the target version to SQL Server 2016 then SSIS does not show a toolbox anymore. If for example one Execute SQL Task was already added to the package then I get a strange square icon with arrows and the error 0x80070057 "The parameter is incorrect" followed by a crash of VS2019 (see screenshot below). My first question is, does SSIS extension 4.5 officially still support 2016 as target version because I read different answers on the internet. Secondly what I'm missing to switch to SQL Server 2016? Any help is welcome because I already spent more than one day on solving this issue without success. FYI: I already tried several times to completely re-install VS2019 and the SSIS extensions. I even tried SSIS extension 4.4 and 3.16 but all result in the same VS2019 crash. VS2019 exception in Application eventlog: Faulting application name: devenv.exe, version: 16.11.34601.136, time stamp: 0x65bc1189 Faulting module name: KERNELBASE.dll, version: 10.0.19041.4046, time stamp: 0xa0505aa2 Exception code: 0xe0434352 Fault offset: 0x0013fa72 Faulting process id: 0x2efc Faulting application start time: 0x01da751cc5bda5f9 Faulting application path: C:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\devenv.exe Faulting module path: C:\WINDOWS\System32\KERNELBASE.dll Report Id: 9c019a44-1e19-4780-9464-184fa73ff0e4 Faulting package full name: Faulting package-relative application ID:Solved1.5KViews0likes1Comment