Umm, you are not worth the time, sorry.

Umm, do some research and you can answer your own question.

Very incorrect, and I can say for sure you have done no research or investigation into engineering development methods at Japanese automakers.

<<But if you try to use a natural key for all tables you will run into some where the natural key is composite which creates its own problems. >>

In my...

I think the reason the Japanese are leaders in quality and productivity in manufacturing is not due to just "standardization". It is due to concepts that are usually described...

It is true in my experience that procedural developers are completely lost when it comes to effective data modeling and schema design, and that the poor models that result cause...

I agree wholeheartedly that there are a lot of arbitrary decisions typically made in custom application development on many levels that could - and should - be standardized. The...

This are a number of issues that can cause this problem. When it happened to me, I fixed the problem by updating to the latest sql server service pack.

A...

Understood Scott. And I think your contribution will likely help me in my work in the future.

And I personally feel that all technical examples offered in venues such as...

Thanks Scott for adding some valuable content re. volume throughput.

One thing I learned after working in a shop that integrated medical claims records (one om my accounts...

Expect to need some non-trivial redesign for performance enhancement when applying a solution that will work well with 3 records to millions.

==Did you do the programmed lookup in SSIS 2005 version?==

Yes. There is no other "production version".

==Is there any other easy way to do this in SSIS 2005.==

Not to my...

I've programmed lookups against text data many times in SSIS. It works great to avoid the overhead of database engine when not needed.

You need to use the scripting component to...

So looks to me we have just about one to one ratio between unique posters and unique (or at minimum _substantially different_ )definitions of what constitutes either a ...

In my opinion, the definition you quote is certainly not the common interpretation of the term and definitely represents a "dumbing down" of the generally accepted interpretation.

But...