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


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:
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)"


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 .


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