dbTalk Databases Forums  

DTS and replication

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss DTS and replication in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ALN
 
Posts: n/a

Default DTS and replication - 04-26-2005 , 10:21 AM






Hi,
I have a publisher and some pushsubscriber with merge replication.

When I insert a textfile (DTSFlatFile) with dts to a publisher table, the
data will be inserted in the publisher table, but the merge-agents don't copy
this new data to the subscriber tables.

What is the reasen for this problem ?
How can I solve this problem ?

Best regards

Axel Lanser


Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: DTS and replication - 04-26-2005 , 11:38 AM






Try turning off fast load for the DataPump task. The replication log reader
would require the transactions to be logged I guess.


Darren Green
http://www.sqldts.com
http://www.sqlis.com

"ALN" <ALN (AT) discussions (DOT) microsoft.com> wrote

Quote:
Hi,
I have a publisher and some pushsubscriber with merge replication.

When I insert a textfile (DTSFlatFile) with dts to a publisher table, the
data will be inserted in the publisher table, but the merge-agents don't
copy
this new data to the subscriber tables.

What is the reasen for this problem ?
How can I solve this problem ?

Best regards

Axel Lanser




Reply With Quote
  #3  
Old   
ALN
 
Posts: n/a

Default Re: DTS and replication - 04-28-2005 , 03:46 AM



Thank you very much,
your answer help me.

Best regards

Axel Lanser

"Darren Green" wrote:

Quote:
Try turning off fast load for the DataPump task. The replication log reader
would require the transactions to be logged I guess.


Darren Green
http://www.sqldts.com
http://www.sqlis.com

"ALN" <ALN (AT) discussions (DOT) microsoft.com> wrote in message
news:7CD04FAB-88D0-43CC-90D0-C915373AE661 (AT) microsoft (DOT) com...
Hi,
I have a publisher and some pushsubscriber with merge replication.

When I insert a textfile (DTSFlatFile) with dts to a publisher table, the
data will be inserted in the publisher table, but the merge-agents don't
copy
this new data to the subscriber tables.

What is the reasen for this problem ?
How can I solve this problem ?

Best regards

Axel Lanser





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.