VERIFIED SOLUTION i

Resolve SQL server error when running Controller.dtsx package on Windows Server 2012 or SQL Server 2012 in Portrait IO, HQ, or Campaign Manager

Issue

An error occurs when trying to run one of the Portrait SQL Server Integration Services (SSIS) packages either directly, or through a registered SQL Server Agent job.

Cause

The original packages may have been compiled under a different SQL Server client connectivity provider. SQL Server 2008 uses Native Client version 10, while 2012 uses Native Client version 11.
If the earlier client provider is not installed, you may get errors when trying to connect to the database with the requested (but missing) provider.

Resolution

UPDATED: April 21, 2017
Carefully read the error messages that are produced, and if they make the suggestion to do so, you can open the configuration file for the SSIS package in question and manually change the version of the SQL Server Native Client provider from 10.1 to 11.1 ('SQLNCLI10.1' to 'SQLNCLI11.1').
Then, when you want to run the SSIS package, make sure that you reference this configuration file. This can be done in one of two ways:
  1. From the command line, when using the DTEXEC command, make sure that you include the /CONFIGFILE parameter and supply the full path and filename of the associated .dtsconfig file, or
  2. If you double-click the dtsx package, make sure that you add the dtsconfig file through the Configuration section in the left panel.
You should never edit the contents of the dtsx packages directly.