September 11, 2008 at 8:20 pm
I have question and confusion. what to do on this situation. working on ssis package runs every night during that update i have seen there is lots of data integrity error. just checking on error i could not clearly see the flow of data. what is the best way to track the database change. i have never use event handler is it a solution for that.. i have already tried ddl trigger which only logged the ddl event... i am trying to avoid trigger on tables for performance issue... what would be the best solution.
Thanks
Sagar
September 12, 2008 at 6:54 am
Sagar,
I'm not sure what you are asking. Do you want to know when an insert or update in your SSIS package causes a data integrity error and be able to see the data that caused it? Or, do you want to log all changes that are being made to the database?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
September 12, 2008 at 8:21 am
Thanks,
ya i wanted to log those changes. i am doing with trigger right now trigger and it will disable after execution complete. Is there any other option with out trigger.
Thanks
September 12, 2008 at 8:30 am
Which changes the errors or ALL data changes?
If you want to see all data changes the best way, IMO, is to use triggers on the table. I suppose in SSIS you could add a new output to your last transform before the insert/update occurs and send it out to another destination table for logging, but you still have a similar impact on your server. The benefit may be that you release locks on the main table sooner, but if you have an error in the logging insert you'd lose the audit trail.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply