Your dimension contains a "effective to" and an "effective from" date and you want to get the surrogate key for your source.date, then the lookup transformation has to be configured to support the requirement.
This is done very clearly with screen shots by Julian Kuiter in her blog. It can be found here
