Share via

Error: "Please select .NET Provider." in Connection Manager, SSIS

Amogh Sharma 0 Reputation points
2024-06-12T15:43:35.9633333+00:00

Hello,

So I am pretty new to SSIS and am trying to use the different Control Flow tasks that show up on the left in Visual Basic 2022. I created a new Execute SQL Task and tried to connect it to the test database I created on SSMS but I got an error in the Connections Manager on creating a new connection that says: "Please select .NET Provider." on pressing OK. Test Connection succeeds. The provider selected is the default Native OLE DB.

Another thing to note is that my default SQL server does not show up when it retrieves the list of servers and I have to type both the server's name and the database name myself. Any help appreciated

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,704 questions
SQL Server | Other
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,441 Reputation points
    2024-06-12T16:31:22.1633333+00:00

    Your post is confusing and has to less detailed informations

    1. Avoid the usage of ADO.NET provider in SSIS package, they don't proform well "by design". SSIS is written in unmanaged code, better use unmanaged data provider = OleDB/ODBC
    2. Select the right data provider. SSDT 2019 and older is 32 bit app and can utilize only 32 bit data provider
    3. ***"*I have to type both the server's name and the database name myself." To lazy to enter a name?
    1 person found this answer helpful.
    0 comments
  2. ZoeHui-MSFT 41,491 Reputation points
    2024-06-13T05:35:21.5133333+00:00

    Hi @Amogh Sharma,

    The default value for OLEBD source is SQL Server Native Client11.0.

    User's image

    my default SQL server does not show up when it retrieves the list of servers

    From my side, it will show all the servers.

    User's image

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    1 person found this answer helpful.
    0 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.