The specified provider is not supported. Please choose different provider in connection manager SSIS

An error in SQL Server Data Tools (SSDT) for Visual Studio while working with SQL Server Integration Services (SSIS) could be due to the missing OLE DB or ADO.NET provider on your machine. This missing component prevents SSIS from establishing a connection, leading to the following error message:

TITLE: Connection Manager
—————————— The specified provider is not supported. Please choose different provider in connection manager.
—————————— BUTTONS: OK ——————————

Cause of the Issue

The error typically occurs when the SQL Server Native Client required for database connectivity is missing or not installed properly. This provider is essential for SSIS to communicate with SQL Server using OLE DB.

Solution

To resolve this issue, you need to install the SQL Server Native Client on your machine. Follow the step-by-step guide below to download and install it properly.

Step-by-Step Guide to Install SQL Server Native Client

1. Download the Installer:

• Visit the Microsoft Download Center.
• Locate the SQL Server Native Client (sqlncli.msi) download link on the page.
• Click the Download button to start the process.

2. Install the Native Client:

• Double-click the downloaded sqlncli.msi file.
• Follow the on-screen instructions in the setup wizard.
• Accept the license agreement and complete the installation process.

3. Restart Visual Studio:

• Once the installation is complete, restart Visual Studio (which contains SQL Server Data Tools).
• Open your SSIS project again and check if the issue is resolved.

Conclusion

By installing the SQL Server Native Client, you enable Visual Studio (SSDT) to correctly recognize the required provider, resolving the error and allowing smooth SSIS operations. If the problem persists, ensure that your Visual Studio and SSDT versions are up to date.

Pro tips:
1. Learn how to migrate SSISDB from one server to another in just a few clicks.

See more