Hi all, am here again almost with the same problem. Am trying to extract data from plain table. i use "Derived Column". There are 4 columns in the source with the pk id, but the problem is, it is only one id column that i see in the destination. i want see all 4 columns including the id column in the destination. any solution? with thanks /M

did you see them in column mapping in destination? http://www.rad.pasfu.com

I am not clear about the requirement. Please provide us some example to make the requirement clear. If you want to consume all the 4 columns from source into one column in destination table, you can use derived column and create a new column using all the 4 source columns.Nitesh Rai- Please mark the post as answered if it answers your question