DTS is an ETL tool in Microsoft SQL server 7.6/7.0/2000 and performs data loading/transformations.
A trigger execute a specific action upon an event, e.g. an INSERT trigger will run whatever code ws assigned to the INSERT trigger whenever a new row is beign inserted. for more info, read a basic DB book or your favorite DB's manual.
Red up on the SQL-92 syntax standard for the lowest common denominator, just be in for a surprise regarding lack of functionality. For performance purposes it's best to code database-specific, otherwise use a tird-party ETL tool between the database sources and targets.
_________________________
There are two types of vessels, submarines and targets.
