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

Native OLE DB

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.