all groups > sql server replication > august 2006 >
You're in the

sql server replication

group:

DTS Data not being Replicated


DTS Data not being Replicated Godd
8/21/2006 2:34:56 PM
sql server replication:
I am importing some data into the subscriber using DTS packages and
these data are not being replicated. Importing the same data into the
same table using .Net code and datasets causes the data to be replicated
properly.

What would cause a DTS to NOT fire the triggers?

Re: DTS Data not being Replicated Hilary Cotter
8/21/2006 2:56:50 PM
Is this merge replication? Have a look at this kbarticle

http://support.microsoft.com/kb/275680/en-us

You can run sp_addtabletocontents to add the rows back.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

Re: DTS Data not being Replicated Paul Ibison
8/21/2006 7:58:15 PM
If you do a fast-load using the Transform Data task in DTS the triggers
won't fire. In merge replication you can run sp_addtabletocontents to get
the extra rows considered.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

AddThis Social Bookmark Button