[ADO NET Source [2]] Error: ADO NET Source has failed to acquire the connection {xxx} with the following error message: "Could not create a managed connection manager.".

Richardson, Matthew R. (SPO) 0 Reputation points
2024-04-23T14:52:57.1+00:00

I am attempting to connect to an Azure database. I am able to connect using SSMS.

However when attempting to run at tasks in SSIS i get the above error

The test connection returns successfully and I can see the preview of the data in the ADO NET Source step but when attempting to run the task it fails with the above error

I am using VB22 with SSIS version 1.3.2.

Azure SQL Database
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Amira Bedhiafi 15,676 Reputation points
    2024-04-23T19:53:01.8133333+00:00

    I would recommend having the following software installed:

    • Visual Studio 2022 (any edition).
    • SQL Server Integration Services Projects 2022 extension v.1.1 for Visual Studio 2022. You can download it from this link.

    Note: It appears Visual Studio 2022 may still have numerous bugs, and you might consider sticking with Visual Studio 2019 for now.

    Update:

    For guidance, please follow this step-by-step tutorial: SSIS Projects Tutorial.

  2. Alberto Morillo 32,891 Reputation points MVP
    2024-04-24T13:25:26.8533333+00:00

    Could you try OLEDB connection instead? Read this article for detailed information.

    0 comments