Viewing 15 posts - 226 through 240 (of 329 total)
Hi Hzhu,
I describe how to make a Lookup do a Left Outer join around Figure 6 in the article. I repeat this process for Right Outer joins,...
June 6, 2008 at 2:22 pm
Great series Steve! And great comments all!
My degree is in Electronics Engineering Technology. In my former career I designed, constructed, delivered, installed, and programmed electrical control systems for manufacturing machinery....
June 5, 2008 at 8:22 pm
Yep - that's it. And I cover that in the example.
:{> Andy
June 4, 2008 at 12:53 pm
Hi Hzhu,
With one exception, you cannot do set-based operations in an OLEDB Destination Adapter (the exception is fast loads). You are stuck with row-based operations most of...
June 4, 2008 at 12:16 pm
You are most welcome. I am sorry I made the errors in the first place, and then took so long to correct them. It's good to hear you were able...
May 28, 2008 at 12:53 pm
What's more important: quality or consistency?
Yes.
There's science to applications and database development, and then there's art. There's function and there's form. Great applications / databases somehow manage to do both...
May 16, 2008 at 8:47 am
UPDATE:
I looked over the article today (finally) and found an error in the way I built the original destination table. It was something that I did not cover explicitly in...
May 12, 2008 at 10:50 am
Wow - lots of good stuff!
For me, I write because of a passion for sharing knowledge (Phil Factor said this much more eloquently on page 1...).
I'm not good at writing...
May 10, 2008 at 9:07 am
Hi Ken,
You are correct. And I hope I made it clear that this article was a proof of concept and nowhere near production-ready code. The intent is...
April 28, 2008 at 11:04 am
Folks, you're right. Thanks for pointing this out and apologies for not doing a better job proofing my code before publication. I will get an updated version out soon and...
April 25, 2008 at 7:23 am
Hi Rick,
SQL Server 2008 includes some help for incremental loads in SSIS. I've blogged about Change Data Capture and SSIS in CTP5 here - it accomplishes exactly...
February 22, 2008 at 3:26 pm
In my experience the SCD is not very efficient once you get above a thousand rows or so.
There's one thing I mention in this article that you can use to...
February 11, 2008 at 6:42 pm
Great comments. I wrote during lunch instead of responding - apologies. I will respond to the questions this evening or tomorrow.
One thing I noticed in my browser, and maybe this...
February 11, 2008 at 11:18 am
Viewing 15 posts - 226 through 240 (of 329 total)