First When you use INSERT/SELECT you should especify the colum list on the insert table and on the select too.

That way you know exactly what goes where.

Secondly your source procedure is returning an sql_variant type which I could guess is coming from one of the serverproperty,databaseproperty(ex) or objectproperty built-in functions in SQL Server and the error *clearly* indicates that you have to convert it to the destination type explicitily.

Cheers,