• I agree, there's always more than one way to crack a walnut with SSIS. I'll do some digging and see what I can find out.

    One thing though: you said that the Conditional Split is good for flat-file destinations? Does that mean that it isn't so useful for Excel spreadsheet outputs? I'm not sure which format I'm going to be using for output yet and while flat-file might be the best solution in terms of record quantities, I don't want to be limited by the wrong choice of method.

    Again, TIA