dts to update table

Hi,
I am writing a dts package to update a sql table using data in a csv
file. I know that dts updates all mapped columns regard less of the column's
value has changed or not. I need to perform a special action when dts
actually changes any column's value but not when the column's value remains
unchanged. Where should I write a query to perform this action?
Thanks in advance.Hi
More information regarding how you are doing this may be useful. The
assumption is that you are loading the data into a staging table or using a
linked server. You also don't say what sort of action this is?
It might be that you want a trigger an checking the original values against
the updated ones, or you could find out which rows would be affected by
comparing the two tables before the update using the UPDLOCK hint to make
sure the data does not change until the end of your transaction.
John
"helpful sql" <nospam@.stopspam.com> wrote in message
news:us$aIcJDGHA.2644@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am writing a dts package to update a sql table using data in a csv
> file. I know that dts updates all mapped columns regard less of the
> column's value has changed or not. I need to perform a special action when
> dts actually changes any column's value but not when the column's value
> remains unchanged. Where should I write a query to perform this action?
> Thanks in advance.
>