Hi Steve,

[1% of community]

Fair enough. Although I think few would complain if the solutions offered for consideration here _were_ scalable. At the very least - in my opinion - the scalability/performance limitations of whatever ETL related solutions are offered in a forum such as this should routinely be mentioned in articles. If there is one thing about ETL we've learned in the last decades it is that the data environment grows quickly!

[perhaps you could come up with something]

No thanks, I just like to criticize (just kidding!!)

In terms of suggestions, I think Rick Todd has provided a really excellent summary. A couple things worth further review perhaps are:

1: discussion of the upcoming SQL 2008 "intersect" and "except" clauses...

2:some "real world" examples in SSIS or SQL (or both) for the more scalable approaches Rick outlines.

Best,

Ken Ambrose