Home Forums SQL Server 2014 Administration - SQL Server 2014 Adding multiple triggers to same table - Recommendations/Best Practices RE: Adding multiple triggers to same table - Recommendations/Best Practices

  • February 19, 2018 at 11:05 am

    #1980301

    SQL!$@w$0ME - Monday, February 19, 2018 12:15 AM

    Thanks Jeff. Primary function of these audit columns is to help load data from oltp to data warehouse using insert/update audit columns using ssis. Thought about cdc, but they find this technically not feasible for these many tables or more work involved. Hence preferred triggers.thanks!

    As I understand things, you are going to create "copies" of changed data to audit tables with triggers, and then use these audit tables to populate a data warehouse with SSIS?

    Is the data in the data warehouse loaded daily? Hourly? Something else? 
    Are there transforms occurring?

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/