Thanks all for your feedback. I ended up changing the process around so that the packages were called using the Execute Package Task so as to keep it all in...

It used to work though when I was running the packages in 2008R2 with MSDB instead of 2012 and the Package Store.

These initial packages are updating lookup tables. I...

Thanks for your reply. What I don't totally understand though is when the package was running in MSDB, it wouldn't end until the package ends. Is the problem now that...

Thanks. I took that approach and it seems to be working well.

The package is set to TransactionOption=Supported. The SQL job is using SSIS. How do I check the security on MSDTC?

This is the production server. On the development server, the...

Local System account. I switched it at one point to the domain admin login though and same result.

Rely on server storage and roles for access control.

I can run it fine in MSDB, it's just when the agent gets involved it errors out.

Quick update...I took the command line string from the job and ran it manually. Had to remove the SMTP connection line but as you can see below, it ran just...