When I add a OLE DB Source that accesses a table that contains a column of data type sql_variant, it generates an error message saying that is an unsupported external data type and will be converted to DT_WSTR. Since there are large values of the float data type, I am concerned that the float values would be truncated.

The only way I have been able to work with sql_variant data types where two databases are involved (source and target of an insert) is using an Execute DTS 2000 Parckage Task. I tried using an Execute SQL Task and got the same message as above. Note that when I access the sql_variant column in an Execute SQL Task that involves only one database, there is no problem.

I would prefer not to use the Execute DTS 2000 Task. How can I do this another way?
Thanks,
Greg