Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Difference between ADO NET source and OLE DB Source in SSIS 2008?

Tags:

ssis

msbi

Can anyone say the Difference between ADO NET source and OLE DB Source in SSIS 2008 ?are they both same in any context ?

like image 291
Balakumar Ezhilmaran Avatar asked Mar 19 '14 09:03

Balakumar Ezhilmaran


People also ask

What is the difference between ADO NET source and OLE DB source in SSIS?

First of all, it is good to know that ADO.NET used OLE DB providers to access data while OLE DB uses ODBC to access relational databases. After giving an overview of these three SSIS connection managers, I will try to illustrate some of the differences between them from an SSIS development perspective.

What is the difference between ADO net and OLE DB?

ADO.NET Connection Managers NET provider. A data reader source can correctly interpret an LDAP query, allowing you to access LDAP services in the data flow. Adodb works with MS-based databases such as Sql Server. Oledb is a standard format supported by a large number of dbs, so you can connect to oracle, db2 etc.

What is ado net source in SSIS?

The ADO NET source consumes data from a . NET provider and makes the data available to the data flow. You can use the ADO NET source to connect to Microsoft Azure SQL Database. Connecting to SQL Database by using OLE DB is not supported.

What is the difference between Sql Server destination and OLE DB destination in SSIS?

SQL Server Destination requires that ETL server and a destination server are the same (not always preferred) OLE DB Destination allows performance optimization by calibrating batch and max commit size. OLE DB Destination allows developers to choose from several data access modes (BULK INSERT is not always needed)


1 Answers

With small datasets there is little difference between ADO NET source and OLE DB Source in SSIS 2008. The difference between them is how they communicate with their underlying data sources. OLEDB talks directly to OLEDB compliant sources, but ADO .NET source talks through a .NET provider. The only reason you should use the ADO.NET source is:

  • There no OLE DB providers available.
  • If you need data access from within a script task.
  • If you need to pass a data source to a custom component.
like image 162
Derrick Bell Avatar answered Oct 11 '22 12:10

Derrick Bell