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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,183 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 42,746 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 34,756 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.

    0 comments