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