• Okay, not sure that I understand fully, but I always try and do as much as possible in my Source query so assuming that you are specifying a SQL query in your OLEDB Source (rather than selecting an entire table), you could maybe use CASE statements to set your column(s) appropriately. That may be what you mean at the very end of your previous post when you state 'better to do it in a query'.

    Regards

    Lempster