Yes, I created both temp tables as physical tables and ran the inserts. They don't contain any sql_variant data types.
I changed the 6 data types in the table to sql_variant and the insert runs successfully now.
I would still like to know how to use the CONVERT function so I could convert to varchar and insert into varchar columns.
Thanks for your ideas..