Search code examples
sql-serversql-server-2008ssis

Difference between .NET, OLEDB, and Native Providers in SSIS

I am pretty confused with the plethora of OLEDB providers found in creating a connection to a database in SSIS 2008 R2.

I would much appreciate if you could tell me what the following providers stand for and when is best to use them:

.Net Providers for OleDB

  • Microsoft OLE DB Provider for SQL Server
  • SQL Server Native Client 10.0

Native OLE DB

  • Microsoft OLE DB Provider for SQL Server
  • SQL Server Native Client 10.0

I am pretty unsure which provider to use out of these if I want to create an OLE DB connection to the database in question. Additionally, I am confused why the same type of provider appears both in .Net and Native.

Solution

  • You really don't have to worry too much about which one to use, select the Native one (SQLNCLI) and it'll work fine out of the box.