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
Change is inevitable... Change for the better is not.