In SSIS appropriate is DT_R8 for Float,Double.

In the destionation table you'd have Float as data type.

Take a look here http://technet.microsoft.com/en-us/library/ms141036.aspx

Regards,

IgorMi