Forum Discussion

Sky_River's avatar
Sky_River
Copper Contributor
Sep 07, 2023
Solved

Oracle float(64) column import to SQL Server error

I am using SQL Server export\import wizard to import one oracle table to SQL Server. Got an error:

 

 

then I change type to float

then I got this

 

 

double click one, then got this:

 

 

I  did add below in C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\MappingFiles\OracleToSSIS10.XML

 

<!-- FLOAT -->
<dtm:DataTypeMapping >
<dtm:SourceDataType>
<dtm:DataTypeName>5</dtm:DataTypeName>
</dtm:SourceDataType>
<dtm:DestinationDataType>
<dtm:CharacterStringType>
<dtm:DataTypeName>DT_FLOAT</dtm:DataTypeName>
<dtm:Length>64</dtm:Length>
</dtm:CharacterStringType>
</dtm:DestinationDataType>
</dtm:DataTypeMapping>

 

I did add below to C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\MappingFiles\MSSQLToSSIS10.XML

 

<!-- float -->
<dtm:DataTypeMapping >
<dtm:SourceDataType>
<dtm:DataTypeName>float</dtm:DataTypeName>
</dtm:SourceDataType>
<dtm:DestinationDataType>
<dtm:CharacterStringType>
<dtm:DataTypeName>DT_R8</dtm:DataTypeName>
<dtm:Length>64</dtm:Length>
</dtm:CharacterStringType>
</dtm:DestinationDataType>
</dtm:DataTypeMapping>

 

 

what can I do fix the issue?

 

Many thanks,

Sky

  • I fixed it now by added below on C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\MappingFiles\MSSQLToSSIS10.XML

    <!-- float -->
    <dtm:DataTypeMapping >
    <dtm:SourceDataType>
    <dtm:DataTypeName>float</dtm:DataTypeName>
    </dtm:SourceDataType>
    <dtm:DestinationDataType>
    <dtm:CharacterStringType>
    <dtm:DataTypeName>DT_FLOAT</dtm:DataTypeName>
    <dtm:Length>64</dtm:Length>
    </dtm:CharacterStringType>
    </dtm:DestinationDataType>
    </dtm:DataTypeMapping>

1 Reply

  • Sky_River's avatar
    Sky_River
    Copper Contributor
    I fixed it now by added below on C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\MappingFiles\MSSQLToSSIS10.XML

    <!-- float -->
    <dtm:DataTypeMapping >
    <dtm:SourceDataType>
    <dtm:DataTypeName>float</dtm:DataTypeName>
    </dtm:SourceDataType>
    <dtm:DestinationDataType>
    <dtm:CharacterStringType>
    <dtm:DataTypeName>DT_FLOAT</dtm:DataTypeName>
    <dtm:Length>64</dtm:Length>
    </dtm:CharacterStringType>
    </dtm:DestinationDataType>
    </dtm:DataTypeMapping>

Resources