SqlShare.com Logo
 
Skip Navigation Links
Home
Video List
Events
Classes
About Us
Login / Register
Subscribe RSS Feed 

Confio Ignite 8

Using the Aggregrate Transform for Group Bys in SSIS

SQL author and MVP Brian Knight demostrates the Aggregrate Transform in SSIS. Similar to a group by? Watch the video to find out!

Duration:
3 mins 4 secs
Skill Level:
100
Rating:
4.37 out of 5
Publish Date:
December 01, 2008
Using the Aggregrate Transform for Group Bys in SSIS You must be logged in to view this video.  
Bookmark and Share
 
1=Poor, 3=Good, 5=Excellent

About the Author

Image of Brian Knight
Owner of Pragmatic Works :: Brian Knight, SQL Server MVP, MCSE, MCDBA, is the co-founder of Jumpstart TV and SQLServerCentral.com. Brian has written and co-written 9 technical books. Brian has spoken at conferences like PASS, TechEd and Connections. Brian develops solutions with Pragmatic Works to migrate DTS packages to SSIS.

References

There are no downloads or recommended reading links for this video

Comments
Ramu Poonjolai on 1/21/2009
go slow

Tariq Bilal on 1/22/2009
Usefull. Thanks brian

R on 2/1/2009
Nice video... -R

aape on 3/20/2009
Gain a lot

Amit on 3/28/2009
very good

Christian Bahnsen on 6/12/2009
another great video

Holck on 6/12/2009
There is an option you didn't cover and that is the "Advanced" button on the "Aggregations" tab, which allows you to create different aggregates all with separate outputs. I think you could have given more info on the "Advanced" tab and the "comparison" and "counts" on the first tab as well. But maybe you felt these too advanced have these planned for a 2nd video?

josh on 6/12/2009
I swear he said the group transfrom was "Asynchronous", but the correct answer is that it is _a_ "Synchronous" transform

Jeannine Takaki on 6/12/2009
Short and paced well.

david mercer on 6/13/2009
Very easily explained and easy to understand thanks

ivan on 6/14/2009
god

Tomer on 6/16/2009
Actually - it is Asynchronous and the correct answer in the quiz should be - "it is Asynchronous, which means all data has to be aggregated before execution can pass to the next step ", and not as shown in the quiz .

Andy Warren on 6/17/2009
Fixed the correct answer - sorry about that!

John Rowell on 6/17/2009
How do you turn off locks in SQL query?

John Rowell on 6/17/2009
How to tell query not to set locks?

Ann on 6/18/2009
need to slow donw a bit...but the vdo is good presentation.

Carla Wilson on 6/22/2009
Actually - it is Asynchronous and the correct answer in the quiz should be - "it is Asynchronous, which means all data has to be aggregated before execution can pass to the next step ", and not as shown in the quiz . ... Ah, Andy - you changed the quiz to accept option 2 as the correct answer, but even though it says "asynchronous" - the reason is wrong. (I chose option 3 because the reason was more correct, and I assumed the typo on "synchronous".)

Andy Warren on 6/28/2009
It's the question from hell! I removed it since it caused so much problem, and sorry again about the confusion:-)

vishal on 7/5/2009
helped a lot ! thx

Kishor Bandi on 7/7/2009
The pace of the exercise could have been a little slower.

vasu contact on 7/12/2009
Using the words Asynchrnous and "fully blocked" are counter intutive because Asynchronous means non-blocking, usually.

Jay Ravindran on 7/15/2009
Nice video....

Dean Gross on 8/13/2009
it would be nice to see some more advanced examples showing the less common aggregation expressions.

Abhishek on 8/30/2009
good one!!!

Suchu on 9/5/2009
thank you

Rajesh on 9/11/2009
Good One!

Sarfaraz Ahmed on 11/12/2009
video is not working

Santosh on 12/22/2009
Video is good but we can pause back to listen something again...this is the problem

Chandhini on 12/29/2009
Nice...

sreenadha on 10/15/2010
Gr8 , gave us full control on agreegate task.

MohanD on 10/21/2010
Great Video's.. How about making videos on Analysis Services like designing the Cube ?

Irfan Mohammed on 2/20/2011
Great presentation.

erick on 7/23/2011
very useful

W. Eric Ashun on 11/3/2011
I wish I could see the sql script for this



Must Be Logged In
 

How Do I Become a Video Author? |  Newsletter History

Copyright © Fourdeuce, Inc., 2005-2009. All Rights Reserved | Privacy Policy | Terms & Conditions