I'm looking for some help with getting started with the SSIS For Each Loop.
I have a process that calls an API based on an ID. It can only make one API call per ID. What I'm looking to do is query a set of IDs, have the ForEach Loop through each single ID, and have the data Upserted to a table.
Here's what I have now. The data flow task does exactly what I need it to do when I manually set the ID I want to pass to it.
Here's my control flow.
The "Get Employee IDs" Execute SQL Task is returning a resultset of IDs like below
ID
00001
00009
00015
00026
I'm going through the options and I'm confused to where to start. I'm guessing I need to have the Execute SQL Task set the variables, then pass them to the For Each Loop?