Convert Column Type: ETL or SQL

Lara

Hi,

 

I have a column that contains letters from a to k and also numbers. 

I would like to replace the letter with 0 and change the column type from text to numbers.

While doing this on ETL the run fails.

 

The way I did it was: 

1- replace text and enter each letter to be replace by 0

2-set column type

I don't understand why I am getting the error! is there a better way to do this?

Thanks!

KVincent

Could you describe the ETL or post a screenshot? Do you know for certain that this is where the ETL is failing? I am wondering if the failure is happening farther downt he line in the ETL.