Post reply

Firing an Update/Insert trigger during data transformation

  • July 19, 2006 at 10:23 am

    #70916

    It appears that my Update/Insert trigger is NOT firing during data transformation. I can later force my trigger to fire in Query Analzyer by manually updating one of my date columns; however, I would rather it fire as the DTS Package inserts the data.

     

    Is there a certain setting I am missing in DTS Transformation ?

     

    Thank you,

    Bob

  • July 19, 2006 at 11:55 am

    #650183

    With SQL Server 2000, go to the Options tab of the transformation properties window and uncheck the "Use fast load" box.

  • July 20, 2006 at 8:54 am

    #650412

    Thank you for your response.

    Bob

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

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