DSXchange

Is there an easy way of converting an incoming data type of "smallint" to a decimal? Or is it just as simple as assigning the target field a decimal(5,2)?


Thanks

dtatem

Try AsFloat() or AsDouble() in the px transformer for a parallel job. Type conversions are explicitly required in a parallel job.
For a server job its as easy as changing the target datatype.