SSIS vs T-SQL Join Performance, Difference Databases on Same server
Given the same specs, would like to know performance 


If your data is on a single SQL Server instance, TSQL joins should always be faster than an SSIS lookup.  This is not really close.  A TSQL query will leverage indexes and statistics, and the cost-based query optimizer.  The join will be performed inside the SQL Server instance, where it is not only more efficient, but it has greater memory and disk resources than an SSIS pipeline.

SSIS lookups are primarily intended for destination-side lookups, heterogenous data scenarios, and for sources without a query processing engine (like flat files).

Further, when your data source is a single SQL Server instance, and your destination is a single (possibly different) SQL Server instance, personally I would almost never use any SSIS data flow transformations.  Instead always using source-system SQL for extract-side transformation, and stage-and-merge for destination-side transformation.