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 ...
Integration Services
  • Sky_River's avatar
    Sky_River
    Sep 07, 2023
    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>
Sky_River's avatar
Sky_River
Copper Contributor
Sep 07, 2023
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