You can use Component Integration Services to maintain referential integrity between remote tables. See the section on constraints in the Transact-SQL User’s Guide. During update, insert, and delete operations, Component Integration Services checks the referenced table. If the check fails, the transaction is rolled back.
