Problem Image:
SOLUTION
This is actually not an issue. You can copy the float at it is. However, due to certain applications that do computation with the values in the column you might want to cast the REAL data type column to DECIMAL (38,10)
Saturday, August 13, 2016
Converting SQL Real Datatype to NUMBER in SSIS
Problem: I have a column in SQL with Real Data type and I want to transfer it to Oracle in a NUMBER data type. In SSIS if I cast the Real data type to Float it generates unwanted float digits
Problem Image:
SOLUTION
This is actually not an issue. You can copy the float at it is. However, due to certain applications that do computation with the values in the column you might want to cast the REAL data type column to DECIMAL (38,10)
Problem Image:
SOLUTION
This is actually not an issue. You can copy the float at it is. However, due to certain applications that do computation with the values in the column you might want to cast the REAL data type column to DECIMAL (38,10)
Subscribe to:
Post Comments (Atom)
-
Hi I was recently working on extracting a table that has 400 columns from a SQL Server DB to load into an Oracle Target Database. I design...
-
In this blog post I will show you how to implement your own custom logging in Azure Data Factory Before you do this please note that Azur... -
Scenario: I want to load data from a SQL Server table that has 1.7billion rows containing a column with data type varchar(max) which is popu...
No comments:
Post a Comment