Yes you can use LOOKUP transformation. What is the issue using this?
Also you can use execute SQL task (exec sproc with variables passed as parms) and do conditional split on result.
Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
The Best SQL Server 2005 Training in the World!