.NET Training at Accenture, Bangalore, Aug 3 – Aug 26, 2015

Just finished .NET GreenField training at Accenture, Bengaluru yesterday. Enjoyed a lot. Enthusiastic participants…:)

20150826_172734

.NET Training at Accenture, Bangalore, July 6 – July 29, 2015

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.

20150729_162433

SQL Server 2012 SSIS and SSAS Training at Wipro Technologies, Kochi, 29 June – 03 July, 2015

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…

IMAG2910

 

C# .NET Advanced Training at Siemens, Bengaluru, 22 – 24 June, 2015

Had nice time teaching C# .NET to Siemens guys at Electronic City, Bengaluru. Enjoyed a lot…

IMG_20150624_154728

 

Tags: ,

.NET Training at Accenture, Bangalore, Apr 6 – Apr 29, 2015

Just finished .NET training at Accenture, Bangalore with 30 participants…

IMG_20150429_172848

.NET Training at Accenture, Bangalore, Feb 16 – Mar 11, 2015

.NET Training at Accenture, Bangalore, Feb 16 – Mar 11, 2015

IMG_20150311_174106

Using OLE DB Data Source in SSIS

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.

Read more…

Tags: ,
Follow

Get every new post delivered to your Inbox.

Join 145 other followers