Replication using DTS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Replication using DTS

Hi, I am trying to implement Transactional Replication using DTS in SQL Server 2000. I defined the Transformations using "Transform published data wizard", such that the source field names are mapped to the fields having different field names in the destination database table. When i try to execute, it failed saying that one of the source field name not exist in the destination table (actually that source field has been mapped to a different field in the destination table). I tried several ways but failed. Did i need to do anyother configuration in the subscriber part? What am doing wrong? Thanks in advance, urs,
Why do you want to use DTS in this case, as the replication process is taken care with pre-supplied SPs for transactional replication? Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.