VERIFIED SOLUTION i

How to have the SSIS packages run on a server other than the main database in Portrait HQ

Product Feature: Customization
 
It is a legitimate requirement for customers to decide that they want the SQL Server Integration Services (SSIS) packages to be run from a server other than the main database server.
For this architecture to work correctly, though, it is important to ensure that close attention is paid to the installation documentation which explains the extra steps necessary to allow this to work.
The necessary steps to set this up are as follows. On the database server, SSIS server and the Portrait Shared Services (PSS) server, run through the following checks:
  1. Log onto the server.
  2. Within the Control Panel | Administrative Tools | Services dialog, check that the Distributed Transaction Coordinator service is started.
  3. Navigate to the Run command line and type dcomcnfg.exe.
  4. In the DCOM Configuration application, expand the tree to Component Services > Computers > My Computer > Distributed Transaction Coordinator > Local DTC.
  5. Right-click Local DTC, click Properties and click on the Security tab.
  6. Check the Network DTC access and also Allow Inbound and Allow Outbound check boxes.
  7. Click OK and exit the Component Services dialog.
DcomCnfg - Local DTC Security tab
 
Once the Distributed Transaction Coordinator service has been restarted, then you should find that the SSIS packages can be run successfully.
If they do not run, then open the package's *.dtsconfig configuration file and check to ensure that the database connection strings are set to use the correct database.
If you still have problems, then you should check whether your firewall is blocking the Microsoft Distributed Transaction Coordinator (MSDTC) application (MsDtsSrvr.exe) or if it is blocking TCP port 135 (RPC). You can test this by temporarily disabling your firewall to see whether the SSIS packages start working.
If you still encounter problems, please contact Pitney Bowes Software Support using the usual email address...
 
UPDATED:  April 20, 2017