Difference between Copy column and derive column transformation

Copy column and derive column transformation are used to add a new column.

Copy column can add new columns only through existing columns

  

But derived column it can add new columns without any help from existing columns.

  

We can add the same column as copy column transformation as well as we can add new column which is not exist on the input and we can assign the new column values as per our requirement. For example

Here I am creating Full name, for full name I have concatenate the (First name, mid name and Last name).  We can’t achieve this using Copy column.

In drive column transformation we are using expression (for manipulating the input column like data conversion, combine the column etc.)

Copy column doesn't support Error Output.

  

Derive column transformation support Error Output.