My task has been changed now a little bit but makes a big diference in code.

I need to setup a trigger so that whenever a certain column is removed from...

Thank you very much man.

Your help is really appreciable.

So if at all i want to write a code for a trigger for deletion of a value then should i write a trigger for UPDATE?

I am not inserting those 4 rows cause they are already in the Schema2.DIMCNAM

I am just leaving them as it is. I dont have to bother about future data since...

I have seen both the tables

Schema2.DIMCNAM has a Identity column col1

Schema1.DIMCNAM also has col1 as identity columns

We dont need to bother about Schema1.DIMCNAM

col1 has only 4 values on common...

I will try to explain my issue in detail

I have a table in two schemas.

Schema1.DIMCNAM and Schema2.DIMCNAM

They are connected through SSIS.

Whatever data is in Schema1.DIMCNAM is there in Schema2.DIMCNAM and...

Thanks for taking interest in my problem

Those identity columns are already been set. I dont have an option to change them.

All i have to do is to create a trigger...

I really appreciate your help man

Thank you very much for this

And about the IF statement

I have like this in my Specification

Original Value --------> ...