CREATE TABLE Audit_tblA (ColA INT

, ColB VARCHAR(50)

, ColC varchar(50)

, AuditAction CHAR(3)

, AuditDate DATETIME Default GETDATE()

, AuditUser VARCHAR(150) Default SYSTEM_User

)

alter TRIGGER tr_UI_tblA ON boat FOR Update,Insert

AS

begin

if update(color)

INSERT INTO Audit_tblA

SELECT inserted.bid,deleted.color,inserted.name,...

Thanks for your response,

It was really helpful but the trigger you created is not worked for the UPDATE. when I am doing the update then it just inserting the new...

Can you please give some more details ?

If its works then its great using case statement,

Sorry wrong title ,,,

Correct one :Insert,update and delete trigger on multiple columns

Its giving me Error:

Error Msg:

Msg 7403, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

No there is no error in the execution tree.

No Its not loading anu data into the Excel Sheet.

Package continious running.

Thanks for your quick response.

I am using SSIS 2008.

I gatheribng the data from two server(linked server) and loading it into Excel.

My destination is Excel Destination.

And It used to be worked...

Thanks for all the response.

Finally I figured out. I have to write there case statement for 3 column.

Thanks for your quick response.

But in CASE statement we can't write

then column4=1

thats not accepted in case statement.

Hey G ,

Your solution is awesome. It was interesting and i learn something new.

But in my senario, I have more than 2 million rows and for every row I have...

Thanks Lutz

My Query is going more that 10 layer down in herarchy. and If i made sample query then its useless.

I can't post the real query. It has company's data.

Is...

Thanks for the response Lutz,

I am still stuck in that problem.

I am not adding the seperate column based on the limit but based on the limit i am just getting...

I am new in to SSIS.

Can you guide me though how can i check that account is same or different for sql server and sql sercer agent?

when i am executing...

Hey Thanks man for your recommandation.

I will try it in my secinario.

Thanks Again