SSIS: How do I query for IDs from 1st database and then select data with only those IDs on 2nd database/data warehouse? There are only 12,000 rows I need data on in the 2nd database/data warehouse but the problem is it has 3M+ rows. I need the second SQL query to constrain it to have only the IDs from the 1st query. TIA!
- 1st database query: select distinct ID from tablename1
- 2nd database/datawarehouse query: select * from tablename2 where ID in (IDs from 1st database query)