ole db destination or sql server destination

Hi, I'm using the datareader source to read data from an odbc connection then the using the ole db destination task (could also use the sql server destination) to load it into sql server. When I load the data into a table I want one of the fields to default to a value. For example,

party_id = mapped from source party_id

party_name = mapped from source party_name

active = 'Y' (I want the field active to default to 'Y')

In the ole db destination or sql server destination tasks it seems like I can't default a value to a field unless it's mapped from the source.

Any suggestions. thanks, Lisa