DSXchange

Ray Wurlod ! thanks for your suggestion, i observed all my input data is decimal but size 18 but output had been set to 4, i need to talk to my lead regarding this on monday, may be this is one prob, what i did is increased the size in my out put stage, but not in database, which i do not have permi...

I have an varchar in source which converted to decimal by using cast function and another field is fload which i rounded to decimal using Round function and every thing else simple mapping, no transofrmations if I put Update action as insert new update existing then the process is going on for ever ...

I have a source as a varchar and target as decimal i am using CONVERT(Decimal(10), "The Source"), but it is not of much help job is trowing warning could some one suggest please

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????

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????

My Source is varchar target is Decimal, i am using CONVERT(Decimal(10), X.GROUP_NO) where is x is source but the process is going on for infinite time, could some one help? suggestions???