Introducion

While testing an ADO.NET connection in the SSIS Upsert Destination, you can get this error message:

The test connection failed because of an error in initializing the provider. 
Keyword not supported: 'ProviderName'.

Root cause

This issue usually occurs when using:

• Visual Studio 2022 (version pre-17.12)
• With SSIS Projects v1.5 extension

This combination introduces a compatibility issue in the ADO.NET connection manager.

Quick Fix Options

Option 1: Update Visual Studio to 17.12 or later (Preview or final release)

Option 2: Downgrade the SSIS Projects extension to version 1.3.2, which is more stable with older Visual Studio builds

🧭 How to check your versions

• In Visual Studio:
  Help > About Microsoft Visual Studio

• SSIS Extension version:
  Extensions > Manage Extensions > SQL Server Integration Services Projects

Full guide with visuals

For screenshots and detailed instructions:
👉 Read the complete guide here