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

ssis msbi
Balakumar Ezhilmaran picture Balakumar Ezhilmaran · Mar 19, 2014 · Viewed 23.6k times · Source

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

Answer

Derrick Bell picture Derrick Bell · Mar 19, 2014

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.

Related questions

Yesterday's date in SSIS package setting in variable through expression

I am setting a variable in SSIS package and I'm using this expression: DATEPART("yyyy", GETDATE())*10000 + DATEPART("month", GETDATE())*100 + DATEPART("day",GETDATE()) The expression will give me a variable value like 'yyyymmdd'. My problem is that I want yesterday's date. …

Read More
what is environment variable configuration in ssis and what registry entry configuration in ssis

I am learning SSIS. Now I'm stuck with configurations. I have done xml, parent package and SQL configuration but I am not understanding what is Environment Variable configuration and what is registry entry configuration in SSIS.

Read More
How to pass variable as a parameter in Execute SQL Task SSIS?

I have ssis package in that I'm taking values from flat file and insert it into table. I have taken one Execute SQL Task in that creating one temptable CREATE TABLE [tempdb].dbo.##temptable ( date datetime, companyname nvarchar(50), price decimal(10,0), …

Read More