• If you refer back to the timeline (minus your spam filter getting in the way, which was quite funny by the way) we were not technically in the midst of a heated debate when I in fact emailed you, at least not on the specific thread that prompted my response. It was right after this post from you.

    THAT's what prompted your message? I guess I shouldn't be surprised but I really am. Did you ever fill in the rest of the solution you posted?

    Shifting gears, you are correct, I've only seen enough of SSIS by helping SSIS developers fix some problems to know that I don't like it for most things. A quote from one of the lines in that connect item sums up my opinion of it. "Using a massive ETL package like SSIS to simply dump a table to flat file is most certainly not a simple solution." I was glad to see you make the comment you did on that particular item. I had stopped following it after the last comment I made on it. Like you, I think MS made a huge mistake in closing that item as "Will Not Fix".

    Of course, except for the last statement in your thread above (which I was very pleased to see), I disagree with pretty much everything else you said for reasons I've previously stated so I'll not waste your time arguing the point any further on this thread.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)