June 28, 2004 at 10:45 am
I have a DTS Package that does inserts into a table using Execute SQL Task. The table i insert into has multiple triggers on insert. ( i haven't written these triggers its part of the application so i can't change them). The problem i'm facing is that not all data is imported into the table ( i'm guessing its because the triggers aren't finishing in time). SO it imports only one record. I tried putting a wait delay and was able to insert three records at most. I dont know what to try next so as to move all the records.
Thank you for your help.
AJ
June 28, 2004 at 11:14 am
I usually disable the triggers and build the sql the triggers are performing into the insert statement - You will also find that it runs quicker. I have tried the two methods before and the triggers definitely slow everything down.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply