PhilipMostert

Author's details

Name: Philip Mostert
Date registered: March 24, 2010
URL: http://www.netdev.co.za

Latest posts

  1. SSIS and Aggregations — March 14, 2011
  2. “Good” SSIS — November 18, 2009

Author's posts listings

Mar
14

SSIS and Aggregations

ssisaggregation

I recently spotted a question about the aggregation task in SSIS, asking if there was an easy way to determine the maximum or minimum value of a group.  This had me confused… I distinctly recall having seen these options in the standard aggregate transformation.  I quickly setup a dataflow and found exactly that: So, on …

Continue reading »

Nov
18

“Good” SSIS

What is “good” SSIS? What is best practice for SSIS packages?  How do I make my SSIS better?  These are all questions I hear a lot.  The answer is never simple but usually include some mention of naming conventions (I have seen too many packages where tasks, sources, destinations and connections are using default names), …

Continue reading »