ChrisM@Work (7/10/2014)
Koen Verbeeck (7/10/2014)
Jack Corbett (7/10/2014)
Koen Verbeeck (7/10/2014)
So I tried to endorse Jeff on LinkedIn for BCP, but somehow it doesn't work.I saw Jeff was endorsed 9 times for SSIS. That was cruel. 😀
I don't know, I bet Jeff would write better SSIS packages than a lot of people who do it full-time.:w00t:
I guess he would have just one Execute SQL Task that calls a stored procedure 😀
So would I - you wouldn't believe the cr@p SSIS tasks I've seen in the last couple of years. Gazillions of DCT's just because some oaf couldn't write decent TSQL.
There is value in that, as it's faster (usually) to transform the stream than it is to double (or more) pass on the data in the staging table doing writes. Depends on the environment and the chagne, though.
However, and this is knowing Jeff's adoration for the SSIS product, I WOULD trust him more than most I've seen code up some utter trash in SSIS. At least Jeff knows he doesn't know.
And yes, Jeff, I remember your challenge. 😀 Every example I have is tied up in NDAs and I'm still trying to find enough time to obfuscate them. The algorithm isn't NDA, it's just everything they're hooked to (multiple vendor systems).
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