Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  DTS Roundtrip from MS SQL To MySQL

Author  Topic  ckndr47 Starting Member 3 Posts Posted - 2006-03-07 : 06:32:10 I have created a DTS Package in MS SQL, the purpose of that DTS is to copy data from MS SQL to MySQL and so far its working fine. Now what i am trying to do is on the updation of records at MySQL i want a trigger which would carry the key (i.e. Primary Key or Reference) and would update the record back in MS SQL (in another table). So its like a round trip, first from MSSQL to MYSQL (i am done with it), now the other trip from MYSQL to MSSQL still unsolved. Remember i have to complete that process using a single DTS Package. Do guide me if you have any idea? Thanks