Transform Data don't fire trigger at destination

#1

Hello All

I use Transform Data Task to copy some data from a source to destination.
When I execute task, transformation of data achieved completely but the
trigger that I created on the destination table don't fire.
Can everybody help me?

Thanks a lot

#2

Hello Hayatbakhsh,

On the Transform data task have you unchecked "Use fast Load"?

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

Hello All

I use Transform Data Task to copy some data from a source to
destination.
When I execute task, transformation of data achieved completely but
the
trigger that I created on the destination table don't fire.
Can everybody help me?
Thanks a lot

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Transform Data don't fire trigger at destination

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

Transform Data don't fire trigger at destination - 03-15-2006 , 04:05 AM

Re: Transform Data don't fire trigger at destination - 03-15-2006 , 06:01 AM