You can create a string variable in SSIS containing your SQL statement. Just add the IDs you extracted to this variable using an expression.
In the OLE DB Source, use the string variable as a source for the SQL statement.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP