One correction - you mention that PK violations can be handled using the DTSLookup feature, but FK violations can't.  Actually, you can, and I have some packages that do just that.