Post reply

DTS and replication

  • September 2, 2004 at 9:14 am

    #102183

    Hi,

    I have successfully setup merge replication between two sql servers. If I add a record to any of the tables through query analyser or through the interface of this db, the new data is replicated to the subscriber.

    One of the tables in the publisher is populated by a DTS (transform data task) from an oracle database and the data is added to this table in the publisher. This new row does not get replicated to the subscribers for some reason. Has anybody seen this before?

  • September 3, 2004 at 5:07 am

    #521615

    Hello,

    You are proberly using BULK INSERT in the DTS package. By using this the triggers needed for the merge replication are not fired. Turn of the BULK INSERT in the DTS package and it should work.

    Regards,

    Hans

  • September 3, 2004 at 5:10 am

    #521616

    Hi Hans,

    Thanks for your reply.

    You are right, I found this article in the Microsoft support site last night:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;275680&Product=sql2k

    For anyone else that experiences this one!

    Thanks again

    Adrian

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply