KB2969781 - FIX: Error when you add a custom connection manager in SSIS 2014 Designer

Applies To

SQL Server 2014 Developer - duplicate (do not use) SQL Server 2014 Enterprise - duplicate (do not use) SQL Server 2014 Standard - duplicate (do not use)

Symptoms

Assume that you have a Microsoft SQL Server Integration Services (SSIS) 2014 project. When you try to add a custom connection manager by using SSIS Designer, you receive the following error:

Note

=================================== The new connection manager could not be created. (Microsoft Visual Studio)

The connection manager '' is not properly installed on this computer. (Microsoft.DataTransformationServices.Design)

For help, click: http:⁠//go.microsoft.com/fwlink?ProdName=Microsoft%C2%AE%20Visual%20Studio%C2%AE%202013&ProdVer=12.0.21005.1&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=ConnectionManagerNotInstalled&LinkId=20476

Program Location:
   at Microsoft.DataTransformationServices.Design.DtsBasePackageDesigner.GetConnectionInfo(String creationName, IServiceProvider serviceProvider)
   at Microsoft.DataTransformationServices.Design.ConnectionManagerDesigner.InitializeConnectionManagerUI()
   at Microsoft.DataTransformationServices.Design.ConnectionManagerDesigner.OnNewConnectionAdded(ConnectionManagerUIArgs connectionUIArg)
   at Microsoft.DataTransformationServices.Design.DtsConnectionService.CreateConnection(String connectionType, ConnectionManagerUIArgs connectionUIArg)"

Resolution

Service pack information

To resolve this issue, obtain Service Pack 1 for SQL Server 2014.

How to obtain the latest service pack for SQL Server 2014

For more information about SQL Server 2014 Service Pack 1 (SP1), see bugs that are fixed in SQL Server 2014 Service Pack 1 .

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.