Share via

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

Alessandro Di Pasquale 15 Reputation points
Feb 20, 2023, 9:37 AM

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.
14,075 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,601 questions
{count} votes

8 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 26,041 Reputation points
    Mar 9, 2023, 7:35 PM
    0 comments No comments

  2. Brenda Woods 0 Reputation points
    Jul 5, 2023, 8:48 PM

    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 No comments

  3. Paul Cudby 0 Reputation points
    Aug 7, 2023, 2:31 AM

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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.