Forum Discussion
Sky_River
Sep 07, 2023Copper Contributor
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
Sort By
- Sky_RiverCopper ContributorI 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>