SQL Server SSIS quandary I have an SSIS job that generates a list of servers from a table, then executes a stored procedure located in an administrative database on each server.

When I try to add one specific server to the list table, it fails trying to set the connection manager for the new server, with the message below.

There is nothing to be found in the SQL Server Error Log, nor in the Event Viewer on either the the server running the job or the one I'm attempting to add.


  Executed as user: CORPORATE\SqlagentPRD. Microsoft (R) SQL Server Execute Package Utility
    Version 12.0.5000.0 for 32-bit
    Copyright (C) Microsoft Corporation. All rights reserved.
  
  Started:
    2:40:56 PM
    Error: 2018-09-26 14:40:58.24
  
  Code: 0xC0209302
  
  Source: SQL Server Log Consolidation Connection manager "SourceQuery"
  
  Description: The requested OLE DB provider SQLCNLI11.0 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode. Error code: 0x00000000.
    An OLE DB record is available.
    Source: "Microsoft OLE DB Service Components"
    Hresult: 0x80040154
    Description: "Class not registered".
    End Error
    Error: 2018-09-26 14:40:58.24
  
  Code: 0xC020801C
  
  Source: Data Flow Task OLE DB Source [30]
  
  Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
    The AcquireConnection method call to the connection manager "SourceQuery" failed with error code 0xC0209302.
    There may be error messages posted before this with more information on why the AcquireConnection method call failed.
    End Error
    Error: 2018-09-26 14:40:58.24
  
  Code: 0xC0047017
  
  Source: Data Flow Task SSIS.Pipeline
  
  Description: OLE DB Source failed validation and returned error code 0xC020801C.
    End Error
    Error: 2018-09-26 14:40:58.24
  
  Code: 0xC004700C
  
  Source: Data Flow Task SSIS.Pipeline
  
  Description: One or more component failed validation.
    End Error
    Error: 2018-09-26 14:40:58.24
  
  Code: 0xC0024107
  
  Source: Data Flow Task
  
  Description: There were errors during task validation.
    End Error
    DTExec: The package execution returned DTSER_FAILURE (1).
    Started:
    2:40:56 PM
    Finished: 2:40:58 PM
    Elapsed:
    1.657 seconds.
    The package execution failed.
    The step failed.
This is probably a typo issue. The provider is SQLNCLI, not SQLCNLI