Hi All, I have my OLEDB source and I have attached it to a "Derived Column" and then attached this to "Import Column". I intorduced the Derived Column because linking straight to the Import column from the source errored with unsupported types when trying to map. I have altered 1 column without problem, but I have a second column where the source type is double-precision float [DT_R8] I have derived the column and told it to replace. The expression I have used is: (DT_STR,15,1252)(col1) No complaints from the Derived Column Transformation editor. When I go to the "Import Column" and select my derived col1, it still says it's an unsupported data type and must be either DT_STR or DT_WSTR ????

Did you creat ea new column in the Derived Column or did you take the original Column? If second, that doesn't work because the original datatype will still be taken. Please create a new column, in the Expression take the orgininal column and do the converting. This new column direct to the destination column.

You can also use the Data Conversion transformation if your requirement is only to convert the datatype of an input column. More information on Data Conversion transformation here. Cheers, ShalinShalin P. Kapadia