We run all of our jobs in several environments and still use the SQL Server Agent or EM to run the jobs. The key is the synchronization of the DTS package ID's across the...
The example given works fine. However, I have experienced issues with using the Dynamic Properties Task to set database connections in nested DTS Packages. Sometimes it worked, sometimes it didn't. ...