foreach - For Each Loop Unable to assign value to a variable -
i have execute sql tasks gets missing ids , stores them objectvariable(missingids of datatype object).using each loop container wanna insert data multi tenant architecture db based on id's name(which name of schema). i've used each ado enumerator , used objectvariable(missingids) ado objectsourcevariable , enumeration mode "rows in first table".in variable mappings mapped variable(companyid) of datatype string index 0. in each container,i wish name of id , store in variable called schema(datatype string).i've used execute sql task getting error. error: 0xc002f309 @ getting schema name accountid, execute sql task: error occurred while assigning value variable "schema": "single row result set specified, no rows returned.". task failed: getting schema name accountid i've used breakpoints , able see data available accountid. anyone knows issue be? thanks vijay