DTS

One quick question....
If I DTS to import some data, does is trigger replication??
I imported a text file using DTS and I don't see the data in my subscriber.
Thank you in advance
Marlene
Marlene,
which task did you use to import the data? If it was the transform data
task, then unchecking the 'fast load' option should cause the triggers to
fire.
HTH,
Paul Ibison
|||Hello,
I'm using the wizard to import Data, and I can not find the option you
mention. Is there any way that I can specify this option using the
wizard??
Thank you in advance.
Marlene A. Roman
**********************
Marlene,
which task did you use to import the data? If it was the transform data
task, then unchecking the 'fast load' option should cause the triggers to
fire.
HTH,
Paul Ibison
********************
One quick question....
If I DTS to import some data, does is trigger replication??
I imported a text file using DTS and I don't see the data in my subscriber.
Thank you in advance
Marlene
|||This option is not available through the import/export date menu itmes, but is available through the DTS services.
When you create a package, right click on your transformation and select properties. Its in the Options tab and is called Use Fast Load.
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html