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

Velja za: SQL Server 2014 DeveloperSQL Server 2014 DeveloperSQL Server 2014 Enterprise

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:
===================================
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.

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.