I was able to get a dts package to change the field in one table, but only by specifying a value for the field.  I tried using a global variable,...

Thanks again.

I'll try dropping the triggers but it will probably be Monday before I have a chance.  I wear more than one hat so it's a really balancing act trying...

Thanks for your reply.

Yes, I've checked the table name and I want to change every record.  In my original post, I was not as clear as I should have been. ...