Skip to Content
0
Former Member
Apr 17, 2014 at 05:34 AM

Decimal to Varchar Conversion

2155 Views


I have source Oracle column COMPONENT decimal (28,7) . Am trying to load this column into Destination sql server , COMPONENT varchar(384)

Source data is like 7153104.0000000 this, i want to load this data into destination with out the decimal values like this 7153104.

I tried using cast , to_char but still am getting the data into destination with decimal values only.How can i avoid them ?

cast(BOM.COMPONENT,'varchar(384)')

when i try this, am getting a warning as well

[Query:Query]
The data type conversion will be used to convert from type <varchar(64)> of mapping expression <to_char(BOM.COMPONENT,'varchar(384)')> to type <decimal(28,7)> of target column <COMPONENT>. (BODI-1110410)