Hello,<BR>I have an asp survey linked to a SQL Server 7 database, which populates fields such as state and address of certain businesses on the survey according to whats in the database. Here&#039;s my problem:<BR><BR>Some of this information (like addresses) will change, so I want to somehow update the information in my dealer_table with the information in my company&#039;s mainframe dealer_table every year. <BR><BR>Is SQL Server&#039;s Data Transformation Service (DTS) the best route to take? Some people advised me to go this route over the use of "triggers"&#062; Does anyone have any info or links to pages showing how to set up a DTS?<BR><BR>thanks in advance!<BR>Herb