Incoming OLE DB source has a float column with a value of 0.0648
Mapping this to a OLE DB Destination column of varchar(15) results in a value of 6.48, off by a factor of 100 !!!
The mapping in the OLE DB Destination show RT8 mapping to DT_STR(15)
While this is easy to reproduce in SSIS, you will not be able to reproduce this in SQL Server with these values.
It can be reproduced at much bigger extremes such as this:
declare @float as float = .0000123456789
select @float, left ( @float, 7 )
=> 1.23456789E-05, 1.23457
Notice how small this number is compared to the value above.
SSIS is not handling this implicit conversion correctly. This should map to the original value in this case. A varchar(15) is large enough to receive this number in scientific notation. SSIS should mimic what SQL Server does in this
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.