MVP Brian Knight brings us some details on the Aggregate transformation in Integration Services.
Runtime: 3:08 minutes
MVP Brian Knight shows how you can use precedence constraints to control the flow of your SSIS packages.
Script components greatly enhance the flexibility of your SSIS packages. MVP Brian Knight shows how you can use this in your transformations.