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.
