Post reply

TRIGGERS NOT WORKING WITH DTS PACKAGE!

  • April 26, 2006 at 11:08 am

    #90894

    Hi,

    On one of my tables I have a trigger to basically remove leading and lagging spaces on an INSERT or UPDATE which works perfect.

    However, I have a DTS package that reads an ASCII text file (csv type) and imports it into the SQL table, it runs and imports without any errors except it ignores the INSERT trigger so the data still contains the leading and laggins spaces!!! If I manually edit it works!!!

    Any ideas?

    Thanks.

    Mike

  • April 26, 2006 at 5:31 pm

    #634463

    Are you useing a Transform Data task to import the data?  If so, uncheck Use fast load on the Options tab of the task properties.  Bulk-copy, by default, won't fire triggers with out the hint FIRE_TRIGGERS and there's no place in The Transform Data task to specify the hint.

    Greg

    Greg

  • April 27, 2006 at 2:59 am

    #634503

    Perfect Greg,

    Works a treat, thank you very much.

    Mike D

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

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