Hi, I am retrieving data from Oracle to Sql server. There are data types mismatch(DT_WSTR and DT_STR). I want to replace input column with new data type. I need to add new column name instead of just replacing the existing column. Finally, there are many input columns without mapping to any columns. Is there any problem with this? Or, how can I replace with input columns

Hello, there is no problem with that. There could be original input columns and then we derive new columns out of them and finally use Derived columns and leave the original input columns without mapping. No issues. Thankshttp://sqlage.blogspot.com/

Hi, I am retrieving data from Oracle to Sql server. There are data types mismatch(DT_WSTR and DT_STR). I want to replace input column with new data type. I need to add new column name instead of just replacing the existing column. Finally, there are many input columns without mapping to any columns. Is there any problem with this? Or, how can I replace with input columns You cannot change the datatype of existing columns. The type and size of a column never changes throughout its lifetime. there are many reasons for this - chiefly it makes the dataflow quick. You also cannot change the name of a column using the derived Column component however you *can* do it from the component from the data originates - the esaiest way to do this is just put some aliases on the columns in your SQL statement. hope that helps. @jamiet http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

While choosing the properties of the derived column choose "Replace the existing column" "Derived Column Select a derived column from the list. Choose whether to add the derived column as a new output column, or to replace the data in an existing column." Note : There is no harm in having unmapped columns.

Sorna, that is not a possibility here. You can't replace columns AND change the data type. One or the other, that's it. Here are some techniques for doing this more reliably. Talk to me now on