Jeff Moden (2/6/2014)
Heh... I'm used to, welcome, and embrace criticism. It's one of the tools I use to learn new things. For example, if someone could prove to me that using SSIS is twice as fast or twice as easy over T-SQL related methods to import text files, I'd take that into serious consideration and would fire up SSIS to start teaching myself more about it. Watching people work with it in previous jobs leads me to believe that isn't the case though and so, much like people that say T-SQL isn't the only answer, I suggest that SSIS isn't the only answer, either. 😉
Challenge accepted. 😎
There are places where T-SQL definately outperforms SSIS. Anytime you have to coagulate the stream (I use that term loosely, but it's appropropriate) for aggregations or sorts, it dies a horrible death.
There are transformations (particularly cascading updates and string manipulations) where SSIS rules.
Jeff, do you have SSIS 2k8 available to you or do you need said examples in 2k5?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA