Designing SSIS Package To Cater To SQL Queries Invloving Multiple Joins

I have  a query that works fine in SQL Server,

SELECT TC.[TestId]
,TS.[NameId]
,[regressionLevel]
,Mstr.[MethodId]
,users.[UserId]

FROM [db_db].[dbo].[TEST] TC
join
[NEW_DB].[dbo].[Users]users
on
users.FirstName=TC.Username
join
[New_DB]..[Method_Master] Mstr
on
Mstr.Description=TC.Method
join
[New_DB]..[TestSource] TS
on
TS.Name = TC.TestName

basically there is a join between three tables to repalce all the varchars to the corresponding ID.

Please guide me in how should I go about in designing my SSIS package to achieve this requirement.

 

thanks in Advance