Greetings,
I have a situation where I need to correct a TON of data in a specific field that gets imported via DTS. I thought I could do so by creating a Trigger.
I guess wrong. Even though the Trigger is set up for INSERT and UPDATE, it doesn't affect the data being imported. I guess DTS doesn't use either. (However the trigger works perfectly for normal Insert and Update T-SQL stmts.)
Can anyone tell me how I can duplicate the effect of a trigger for DTS imported data?
For example, I have common appreviations like 'Nash', whereas it should read 'Nashville'; 'Buff' where it should be 'Buffalo', etc...
Thanks
I have a situation where I need to correct a TON of data in a specific field that gets imported via DTS. I thought I could do so by creating a Trigger.
I guess wrong. Even though the Trigger is set up for INSERT and UPDATE, it doesn't affect the data being imported. I guess DTS doesn't use either. (However the trigger works perfectly for normal Insert and Update T-SQL stmts.)
Can anyone tell me how I can duplicate the effect of a trigger for DTS imported data?
For example, I have common appreviations like 'Nash', whereas it should read 'Nashville'; 'Buff' where it should be 'Buffalo', etc...
Thanks