Thanks for the update.

I managed to come up with a work around as well.  I was able to write an SP that did the job with no problem.  I automated...

Can't offer any solutions for you, can only commiserate.

Have  a DTS package that simply copies records from one table to another inside the same database.  Datatypes for all fields match. ...