I am new to SSIS. I need to convert the following code to a result set that I can then pass to a ForEach loop container:
SELECT @LoadDt = GETDATE();
SELECT @LoadDt, Branch__Number
WHERE [LoadToDataStore] = 1;
What I have done so far is create an Execute SQL task that gets the date variable. I have created an Execute SQL task that returns the branch numbers I want. I need to return the branch numbers and the date in such a way that I can pass them to a ForEach loop that will call a number of tasks for each branch number, and pass both the branch number and date to the tasks as parameters. For tracking purposes, I want the date value to remain constant during the package run, so I can't get the date each time I loop.
The greatest obstacle to discovery is not ignorance - it is the illusion of knowledge.