SQL Server 2022 Developer Edition - Installation of the SSIS Integration Services

Alessandro Di Pasquale 10 Reputation points
2023-02-20T09:37:55.24+00:00

Hello to all,

I have been trying to do the one Integration Services installation on my SQL Server 2022 Developer Edition environment. Unfortunately I always get errors during the installation, these are mainly related to the installation of Microsoft OLE DB Driver for SQL Server.
The message is:
The feature you are trying to use is on a network resource that is unavailable.
Use source:
C:\ProgramData\Package Cache{CD711320-8704-46EF-8B09-0F40BD2A4C2F}v18.6.5.0\x64\

If I then use the 'Cancel' button, the following message appears;
An installation package for the product Microsoft OLE DB Driver for SQL Server cannot be found. Try the installation again using a valid copy of the installation package 'msoledbsql.msi'.

The next error message is then:
Microsoft ODBC Driver 17 for SQL Server and the following reousce is searched:
C:\ProgramData\Package Cache{CBA9B46D-5C8E-46F9-94B4-7024400EDE52}v17.10.3.1\x64\

Can anyone please offer help, I am currently evaluating the ETL tool for my company and would like to map the whole process with SSIS. But I am blocked now.

Thank you very much in advance.

The summary log file says the following:

Detailed results:
  Feature:                       Scale Out Worker
  Status:                        Failed
  Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name: Microsoft OLE DB Driver for SQL Server
  Component error code:          1706
  Component log file:            C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230220_101823\msoledbsql_Cpu64_1.log
  Error description:             An installation package for the product Microsoft OLE DB Driver for SQL Server cannot be found. Try the installation again using a valid copy of the installation package 'msoledbsql.msi'.
  Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=16.0.1050.5&EvtType=msoledbsql.msi%40InstallFiles%401706

  Feature:                       Scale Out Master
  Status:                        Failed
  Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name: Microsoft OLE DB Driver for SQL Server
  Component error code:          1706
  Component log file:            C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230220_101823\msoledbsql_Cpu64_1.log
  Error description:             An installation package for the product Microsoft OLE DB Driver for SQL Server cannot be found. Try the installation again using a valid copy of the installation package 'msoledbsql.msi'.
  Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=16.0.1050.5&EvtType=msoledbsql.msi%40InstallFiles%401706

  Feature:                       Integration Services
  Status:                        Failed
  Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.
  Component name: Microsoft OLE DB Driver for SQL Server
  Component error code:          1706
  Component log file:            C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\20230220_101823\msoledbsql_Cpu64_1.log
  Error description:             An installation package for the product Microsoft OLE DB Driver for SQL Server cannot be found. Try the installation again using a valid copy of the installation package 'msoledbsql.msi'.
  Error help link: https://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=16.0.1050.5&EvtType=msoledbsql.msi%40InstallFiles%401706
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,216 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,503 questions

8 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 25,726 Reputation points
    2023-03-09T19:35:28.6+00:00
    0 comments
  2. Brenda Woods 0 Reputation points
    2023-07-05T20:48:42.4333333+00:00

    Having the same issue with installing 64 bit SQL Server 2022 Standard Edition. I have the MSOLEDBSQL driver installed and still get the message.

    Then I also get the Microsoft ODBC Driver 17 error message. I should not have to install these prior to the install.

    Anybody know what the issue is? I know it's os related as I've tried a couple of different copies of the install software.

    0 comments
  3. Paul Cudby 0 Reputation points
    2023-08-07T02:31:10.21+00:00

    uninstalling SSMS and rebooting and then reinstalling from the latest online version solved the problem for me

    0 comments