The problem with running Dtexec three times, assuming you meant having either three steps in a single job or three individual jobs is that the process needs to create a control file to be put in the Outbound directory after all the steps\data is there. That is the trigger for the vendors system to know that all files are ready. So I thought I could put the first 3 packages (which are the same child package) in a sequence container and then the fourth package would handle moving the control file to the outbound directory. But I can't have the master pass in the variable that the child packages uses to run the stored procedure. Because if all three children have a variable cfg_ExtractType and its source is parent then I am stuck. Unless I am misunderstanding where you are running dtext from. Is it possible to have the sql job run dtexec to call the master and then the master call dtext on each package passing in cfg_ExtractType via the /SET switch?