SSIS - 在另一个表上执行查找以获取相关列

I want to executing a select statement in SSIS, but this select statement takes a parameter from another component, and the column of this select statement must be used as inputs to other components.I want to executing a select statement in SSIS,