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

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

8 answers

Sort by: Most helpful
  1. Alexander Bufalo 50 Reputation points
    2024-01-22T21:57:29.4066667+00:00

    This issue can happen if you have any version of Microsoft OLEDB or ODBC drivers already installed. INstalling another driver on top of it won't fix. The set up seems to do a pre check and not extract those two msi because it understand it will not use it, but then it tries to install them and the files are not there, of course.

    To fix, go to add/remove programs and remove any version of microsfot oledb and odbc, then relaunch the setup.

    10 people found this answer helpful.

  2. Olaf Helper 45,126 Reputation points
    2023-02-20T10:16:01.3233333+00:00

    Microsoft ODBC Driver 17 for SQL Server and the following reousce is searched:

    You can try to install the ODBC manually before, to advoid this issue:

    https://learn.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16

    => Version 17

    1 person found this answer helpful.
    0 comments No comments

  3. Alessandro Di Pasquale 15 Reputation points
    2023-02-22T19:17:05.1333333+00:00

    Hi to all,

    Thank you for your sucestion. I wil try to install the driver manually, so that perhaps the installer will skip this section of the procedure.
    I will let you know.

    1 person found this answer helpful.
    0 comments No comments

  4. ZoeHui-MSFT 37,991 Reputation points
    2023-02-22T01:26:46.64+00:00

    Hi @Alessandro Di Pasquale

    Please try to install ODBC manually to see if it could resolve the issue.

    Regards,

    Zoe Hui

    0 comments No comments

  5. Alessandro Di Pasquale 15 Reputation points
    2023-03-09T19:20:39.5866667+00:00

    Hi to all.

    I am not getting anywhere, the setup wizard still has a problem with the missing msoledbsql.msi.

    Do you have another idea? Thank you very much for your help.

    Alessandro

    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.