How to split a column content using SSIS?

Question

A column is like (000000000000054390- )in the source table which denotes -543.90 .i need the destination as -543.90. How this can be done using ssis ?

Thanks Arif

Answer 1

Use a Derived Column object in your Data Flow Task.

You can then do a SUBSTRING (assuming that this is a string) manipulation on your number, which can in turn be cast into its proper data type.