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.
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.
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:
Just finished .NET GF training at Accenture, Bangalore. I really enjoyed this batch…Best of luck guys!!!
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…:)
Wow!!! Awarded with the Microsoft Certified Trainer (MCT) for the third consecutive year. Thank you, Microsoft.
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…
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…