Just finished .NET GreenField training at Accenture, Bengaluru yesterday. Enjoyed a lot. Enthusiastic participants…:)
Just finished .NET GF training at Accenture, Bengaluru…Glad to know that 80% participants passed online and practical test. Enjoyed at the location as it was nearby my home i.e. Bang-8 this time…Thanks to the Accenture for the opportunity.
Just finished 5 days SQL Server 2012 Integration Services and Analysis Services at Wipro Technologies, Kochi. Enjoyed teaching Microsoft BI tools, especially Analysis Services.
Working with Dimensions, Hierarchies, Partitions, Aggregations, etc. is really challenging.
Thanks to all participants at Wipro for inviting me. Trust we’ll be meeting in future as well…
A data source in SSIS package is something which helps us to connect to the source of data like RDBMS, CSV File, Excel File, etc. and pull the data out.
A data source is used when we’re using Data Flow task. I’m sure you know about the Data Flow task, which is widely used, almost in every package. :)
There are various data sources such as ADO.NET, OLE DB, Flat File, Excel File, Raw File, etc. We choose a data source based on our requirement, from where we’re going to pull the data out.
Today, we’ll be talking about OLE DB Source, which can connect to almost all kinds of existing data sources, whether it’s SQL Server or Oracle or SAP NetWeaver or Access, etc. OLE DB uses the Connection Managers behind the scene in order to connect to a data source. It’s not Data Source but a Connection Manager decides what kind of driver you’re going to use and what database or data source you’re connecting to.