Different Tabs Inside Package Designer in SSIS

When we create a new package in SSIS 2012 project, we get a package file showing following tabs in the designer area: Controls Flow, Data Flow, Parameters, Event Handlers and Package Explorer. Lets discuss about these tabs a little bit.

Control Flow:
This is the first tab in the designer. We can drag and drop different types of Tasks from SSIS Toolbox. Here we can group the tasks using different types of containers like Sequence, For Loop or Foreach Loop. We can define precedence constraints over here to give desired flow to the tasks.

Blog_1

Read more…

Where SSIS, SSAS and SSRS Fit into Business Intelligence?

This is a very common question that I always ask to my participants on the very first day of Business Intelligence training. And, to my surprise, only a few guys know about it. It’s not their fault. They work on particular technology for longer period and stuck with that. So, they just bother to handle their day-to-day life work and get away. So, I thought to discuss this topic a little bit so that everyone, especially the beginners are aware of this basic knowledge/fact.

At first, what’s this buzz word called “Business Intelligence”? And the answer is: a process that empowers high-level management to take decisions faster based on analytical data.

Before I get started, lets see the image below:

BIDiagram

Read more…

.NET Training at Accenture, Bangalore, May 22 – Jun 17, 2014

Just finished .NET GF training at Accenture, Bangalore. I really enjoyed this batch…Best of luck guys!!!

IMG_20140617_165200

MDX Training at Steelwedge Technologies, Hyderabad 06 – 15 May, 2014

It’s been really nice experience to conduct MDX sessions at Steelwedge Technologies, Hyderabad for the second time. Nice participants. Enjoyed Hyderabad stay with Karachi Bakery stuff at Madhapur…:)

DSC_0185

Awarded with Microsoft Certified Trainer (MCT) for 3rd Year

Wow!!! Awarded with the Microsoft Certified Trainer (MCT) for the third consecutive year. Thank you, Microsoft.

MCT 2014

A Must Read: MDX with SSAS 2012 Cookbook

I have gone through a few chapters and found them very useful. The concepts have been explained nicely and easier to understand. Thanks a lot to my friends Sherry Li and Tomislav Piasevoli for this book.

A must read for beginners who wish to learn MDX…

mdx

 

 

 

SQL Server 2012 Programming Training at Siemens, Bengaluru, 29 – 30 Apr, 2014

Finished SQL Server 2012 Programming training with 13 participants at Siemens, Bengaluru yesterday. The participants had so many queries on fundamentals, which we always ignore while learning. Nice experience.

I’m amazed to see that SQL Server is so vast now…so many new programming features…At times I get confused what to teach and what to ignore…Everything seems important for developers…Unfortunately, couldn’t take pic though…

Follow

Get every new post delivered to your Inbox.

Join 133 other followers