Hi All,

In my SSIS package, i have a field test_method_number coming from OLE DB Source. I used Derived transformation to trim test_method_number: TRIM(test_method_number)

Now in the next Derived Transformation, i see duplicate test_method_number. How to get rid of this duplicate?

Double click on the Derived Column component to open Derived Column Transformation Editor - Choose Replace 'Your Column Name'

I tried your method but the issue is not resolved.

Hi SyedF,

Delete your Derived Column Transformation.

Do it again and choose replace "column name".

I tried your method but the issue is not resolved.

Delete your existing Deriver Column Transformation and and follow instructions as per my previous reply.

Cheers

Ronnie