Error using SQL Server 2019 Import and Export Data (64-bit)
Hmm interesting it's calling out SSIS. This is just going out in a limb, but can you use the SQL installer to ensure SSIS is installed and then retry: https://docs.microsoft.com/en-us/sql/integration-services/install-windows/install-integration-services?view=sql-server-ver15
Hopefully that fixes the underlying issue.