Hi all . I have an input datatype which is a string and when it goes from the source to staging I need to convert it into a float.
Could anyone help me on to use the derived column transformation to convert it into a float.
Amount_dollar(nvarchar) need to be changed to float.
I am unsure how to perform it.