Well done, Michael, you were very thorough in your description. I, however, am having problems executing package tasks when running from dtexec.exe. I receive the following error:
Error: 2017-08-03 12:56:02.72
Description: There is no project to reference.
The first package copies data from the source system into .csv files.
The second package copies the .csv files into tables in a staging database.
The third package transforms the new tables into dimension and fact tables.
The fourth package loads the dimensions and facts from the staging database to the reporting database.
The Execute Package Tasks are referencing Project Packages
Have you seen this before and what are some solutions I might want to try?