First of all, I have a MS SQL server 2008 Std. edition on my server and I have a linked server between Oracle and SQL server 2008. I try to take data from Oracle server to SQL server and I have a problem like this:
When I try to convert one column nvarchar
to Float
it gives error like this:
Error Converting data type nvarchar to float.
But when I try to make same job with SQL server 2008 R2 it doesn't give any error and works fine.
I know It caused by Decimal symbol (.
and ,
) but is there anything to fix this situation and provide it to work on also SQL server 2008 std. edition?