so you mean to say that I should store the package path in a sqlserver table. then I should use foreach container and declare a variable say v_package of type object and should loop the table to get the package path. is that correct?

but in my case I require the packages to be executed in a particular sequence. that's why I am using execute package task for each packages and picking the package location from file system which happens to be the connection manager for each package.

Can you please suggest if I can do anything different here in order to run the master package from sqlserver agent?

Thanks