I have a query like "Select tablenumber from a table"
So, if i get values 1,2,3
1 executes Packge ----pacakge1
2 : execute Packge ---pacakge2
3 : Execute Packge ---Pacakge3 etc..
my solution is not working :
Execute SQL task : Calling the query . i get 5 values example:1,2,3,4,5 and passing that value into variable
In precedence constraints : i check the value from variable and based on value , i call execute package. But now, only "execute package" is being called only one time.
how to make it work to run all the packages as my query has 1,2,3,4,5 values returned.