DSXchange

my source is float target is decimal if i map directly some of the data is being lost and my job is throwing warnings, i am using format function but it not of much help, could some one hel or Suggest????

What are the SQL type,Length and scale you have used in your source/target stages?

Promoting from float to decimal only requires that you have the appropriated length and scale in the decimal column. No transformation is necessary.