Paul Hernández (7/25/2013)
The situation is the following:- I have an OLE DB source.
- Then I perform some lookups and splits
- I update some records using an OLE DB commmand
- Then I would like to store some values from a column (the id of the accounts that were updated in this case)
I though I can use a script component to store these values in a variable and then iterate the variable in other data flow task or using a for each loop.
At the moment I solved the problem in another way but I´m still curious and I would like to know if that could be made.
The OLE DB Command doesn't allow you to inject a returned value back into the pipeline. Probably the easiest to get that would be to do a lookup based on the where criteria you would have used in the OLE DB command to get the ID into the pipeline then use that ID as the WHERE criteria.
But as I reread what you want to do I am confused by the process, you have a set of actions that culminate in an OLE DB Command, why do you need the IDs and why do you need to iterate through them? I must be missing something.
CEWII