June 16, 2003 at 12:59 pm
Hello everyone,
I have a DTS package that imports data from an Oracle database to a SQL Server database. The table that the data is being loaded into has an INSERT trigger defined on it that copies the newly inserted record into a history table. However, when I run the DTS package to do the load, the data is loaded okay, but the trigger doesn't seem to fire because the history table is never refreshed with the most recent data loaded. Does anyone know what's causing this and if it can be fixed?
Thanks,
Jason
June 16, 2003 at 1:45 pm
Hello.
By default a Transform Data Task is set to 'Use Fast Load' which causes it to do a bulk insert. If you click off this option (and thereby go to a row by row insert process) then the trigger shouldn't be suppressed.
Everett
Everett Wilson
ewilson10@yahoo.com
June 16, 2003 at 3:04 pm
Thanks Everett! I will give it a try later in the week when they get data back into the Oracle database and let you know if that did the trick.
Jason
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy