Add Set XACT_Abort oFF to the beginning of your trigger. to my knowledge, that is the only thing you can do as a workaround.

Try this, should work for you.

CREATE TRIGGER a_insert ON a

FOR INSERT

AS

BEGIN

Set XACT_Abort oFF

begin try

DECLARE @a AS VARCHAR(40)

SET @a = 'count of transaction'...

Thanks for the answer. I had tried to create the temp table in the trigger and then use it up in the proc. but it did not work. but if...

Thanks for the answer. I had tried to create the temp table in the trigger and then use it up in the proc. but it did not work. but if...

Thanks. MSDn says the ref can only be SQL table. Does not it suck??!!

We are using SSIS 2012. No we don't have a plan to dump data in SQL.

I know that it can be used in MS Excel.

http://oakdome.com/programming/SSIS_FuzzyLookup.php

Eric the loop in this level does not iterate the tables or any other Enumeration. It is just a simple loop.

the tables' loop sits below the code shown:-)

But I have already done that with interop dll.

Come on Eirikur, it is not that similar!:Whistling:

Thanks Phil for the answer.

The rules are not too complicated to be done through T-SQL or Access query or VB scripting.

Although they are many in number. They are mostly...