Home Forums SQL Server 2008 SQL Server 2008 - General use trigger or better option? RE: use trigger or better option?

  • July 13, 2014 at 5:00 pm

    #1729004

    KoldCoffee (7/12/2014)

    because I explained to you at least a couple of times, I can't use the ssis package because it is a slow solution. Therefore I'm not using SSIS.

    Heh... OK. I'm officially confused. You said the process was being controlled by SSIS, correct? Can you change that?

    And, even if the answer is "no", a trigger isn't going to make things faster for you whether you're using SSIS or not. Again, I might be misunderstanding something but, no matter what the process is, the process is done when the process is done. That's the only time you should query the table to see if everything was done correctly, not every time you make an entry into a table.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)