Floating FB popout byF5debug

SQL Server Integration Services (SSIS) – Part 33 – Aggregate (SUM) Transformations Control in SSIS

 

This is part 33 of the series of article on SSIS. In this article we are going to see on how to use an Aggregate (SUM) data flow transformation control in SSIS packaging.

Introduction:

In this article we are going to see on how to use an Aggregate (SUM) data flow transformation control in SSIS packaging. With this function operation we can get a Summation of a number of rows necessary to get result in desired format. Let’s jump into to the example on how to use this control in real time.

You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx

[more]

Steps:

Follow steps 1 to 3 on my first article to open the BIDS project and select the right project to work on integration services project. Once the project is created, we will see on how to use an aggregate control for summing the rows and give as a single column

Here we will see on the SUM operation in the aggregate control. I have added an OLEDB connection which fetches the data from the database upon which we are going to do summation of number of rows and then pass it to a file destination as shown in the below screen

clip_image001

Here last 2 controls shows a red mark inside the control indicating that the control is not configured. We step forward and configure the same. Now double click on the Aggregate function will open a pop-up windows as shown in the below screen

clip_image002

Here we are selecting the columns on which we need a SUM as shown in the screen. And after selecting the numbers of columns for summation then click on the OK button to get configured. Now configure the Flat File Destination as shown in the below screen.

clip_image003

Once everything is configured your screen will look as shown in the below screen

clip_image004

Now Hit F5 will run the application and show the output as shown in the below screen

clip_image005

Here the numbers of rows are indicated at the bottom of the each control as shown in the above screen. And finally the results (SUM of rows resulting in a single column) are loaded to flat file destination which looks like below

clip_image006

Conclusion:

So in this article we have seen on how to do a Summation of a rows using an Aggregate function transformation in data flow tab.

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter
F5debug | Telerik Webinar – Sharper your .Net Ninja skills

Floating FB popout byF5debug

Telerik Webinar – Sharper your .Net Ninja skills

 

Telerik has released a recent build and we have new stuffs to know with the latest release with the Telerik Webinar scheduled between February 20th to February 22nd and the Registration for Q1 2012 Webinar Week is now open, so we can book our seat right away and block off the time in our calendar to brush up on all the cool new things coming from Telerik.

At each webinar there will be draw for Telerik Ultimate Collection license worth $1999. The Ultimate Collection contains the newest product – Kendo UI – everything we need to build sites and mobile apps with HTML5 and JavaScript. To get eligible for the draw we need to attend the session live and participate in the Q&A sessions.

Register for the Session using the link – http://www.telerik.com/support/webinars.aspx

Day 1 – Mon, Feb 20

clip_image001clip_image002clip_image003clip_image004

 

 

 

 


9:30 AM – 10:30 AM
What’s New in XAML – RadControls for Silverlight and WPF

11:00 AM – 12:00 PM
What’s New in Test Studio

12:30 PM – 1:30 PM
What’s New in Data Tools – OpenAccess ORM

2:00 PM – 2:30 PM
What’s New in RadControls for WinForms and Reporting

clip_image005clip_image006clip_image007clip_image008

Day 2 – Tues, Feb 21

9:30 AM – 10:30 AM
What’s New in ASP.NET

11:00 AM – 12:00 PM
What’s New in Tools for Better Code

12:30 PM – 1:30 PM
What’s New in Mobile – RadControls for Windows Phone

clip_image009clip_image010


Day 3 –
Wed, Feb 22

9:30 AM – 10:30 AM
What’s new in KendoUI

11:00 AM – 12:00 PM
What’s new in Sitefinity 5.0

12:30 PM – 1:30 PM
What’s new in TeamPulse

(All times are Eastern Standard Time)

Couple of months I am working on with the Sitefinity product to build a website and I am really looking for the webinar on this product. Every one can make use of this opportunity and get the best out of the webinars.

Happy Programming!!!

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Comments (1) -

www.newasiainconline.com
www.newasiainconline.com
3/22/2014 2:58:19 PM #

I am sure this paragraph has touched all the internet users, its really really nice piece of writing on building up new webpage.|

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter