SSIS Installation Issues

[mdemaris2001]

Hello all,

I am attempting to install SSIS package into VS2019 CE.  I have posted a thread on SQL Server Central as well, hoping to reach a broader range of experienced devs and DBA's.

SSIS Installation Issues – SQLServerCentral Forums

Hoping you can help, thank you.

Mike

[#2]

and?!? saying that you have an issue with no information is not very useful unless we can read minds. Please provide all the relevant information you can find including and not just error logs, error message (as text + as screenshot).

Note! Please don't send us to search for the information. If you started more than one discussion (which is perfectly OK) then you should sync the information between all threads and make sure that no one spend time on what was answered in another thread.

[#3]

@Ronen_Ariely 

Ok, well here is some text from various logs:

Package Microsoft.Windows.UniversalCRT.Msu.81 is not applicable: The current OS Version '10.0.22621.0' is not in the supported version range '[6.3,6.4)'.
[3160:0006][2023-03-27T15:04:47] Package Microsoft.Net.4.7.2.FullRedist is not applicable: The current OS Version '10.0.22621.0' is not in the supported version range '[6.1.1,10.0.16299]'.
[3160:0006][2023-03-27T15:04:47] Package Microsoft.VisualStudio.Debugger.DbgHelp.Win8 is not applicable: The current OS Version '10.0.22621.0' is not in the supported version range '[6.1,6.3]'.
[3160:0006][2023-03-27T15:04:47] Package Microsoft.VisualStudio.Debugger.Remote.DbgHelp.Win8 is not applicable: The current OS Version '10.0.22621.0' is not in the supported version range '[6.1,6.3]'.
[3160:0006][2023-03-27T15:04:47] Package Microsoft.VisualStudio.Debugger.Remote.DbgHelp.Win8 is not applicable: The current OS Version '10.0.22621.0' is not in the supported version range '[6.1,6.3]'.
[3160:0006][2023-03-27T15:04:47] Package Microsoft.VisualStudio.NuGet.PowershellBindingRedirect is not applicable: The current OS Version '10.0.22621.0' is not in the supported version range '[6.1,6.2)'.
[3160:0006][2023-03-27T15:04:47] Package Microsoft.Windows.UniversalCRT.Msu.7 is not applicable: The current OS Version '10.0.22621.0' is not in the supported version range '[6.1,6.2)'.
[3160:0006][2023-03-27T15:04:47] Package Microsoft.DiagnosticsHub.KB2882822.Win7 is not applicable: The current OS Version '10.0.22621.0' is not in the supported version range '[6.1,6.2)'.
[3160:0006][2023-03-27T15:04:47] Package Microsoft.Ancm.IIS.Msi is not applicable: Required conditions are not satisfied: IISCoreWebEngineInstalledx64 And IISW3SvcInstalledx64
[3160:0006][2023-03-27T15:04:47] Package Microsoft.Ancmv2.IIS.Msi is not applicable: Required conditions are not satisfied: IISCoreWebEngineInstalledx64 And IISW3SvcInstalledx64

3/27/2023 14:59:10 - Capping recursion at 6 directories in each extension root due to 'default limit behavior'.

3/27/2023 15:00:40 - Blocking processes:
3/27/2023 15:00:40 - Microsoft.ServiceHub.Controller.exe (5340) : C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\ServiceHub\controller\Microsoft.ServiceHub.Controller.exe
3/27/2023 15:00:40 - ServiceHub.SettingsHost.exe (15284) : C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\ServiceHub\Hosts\ServiceHub.Host.CLR.x86\ServiceHub.SettingsHost.exe
3/27/2023 15:00:40 - ServiceHub.VSDetouredHost.exe (8816) : C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\ServiceHub\Hosts\ServiceHub.Host.CLR.x86\ServiceHub.VSDetouredHost.exe
3/27/2023 15:00:40 - ServiceHub.IdentityHost.exe (11564) : C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\ServiceHub\Hosts\ServiceHub.Host.CLR.x86\ServiceHub.IdentityHost.exe
3/27/2023 15:00:40 - Microsoft Visual Studio (10484) : C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\devenv.exe
3/27/2023 15:00:40 - ServiceHub.Host.CLR.x86.exe (18480) : C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\ServiceHub\Hosts\ServiceHub.Host.CLR.x86\ServiceHub.Host.CLR.x86.exe
3/27/2023 15:00:43 - Blocking processes:
3/27/2023 15:00:43 - Microsoft.ServiceHub.Controller.exe (5340) : C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\ServiceHub\controller\Microsoft.ServiceHub.Controller.exe

I just realized that the VSTA hosting core logs seem to have logged for about a minute.  I copied these logs while the installer was running.  Afterwards, I forced the installer to shutdown.  It was at about 25% for over an hour.

I will try again when time permits, and log the start time and the time I force it to stop.  Maybe that will help track down the stalling app or code.

[#4]