Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

SQL Server Log Provider error when you configure SSIS in SQL Server 2014 Developer and SSDT


View products that this article applies to.

Symptoms

Assume that you configure SQL Server Integration Services (SSIS) packages on an instance of SQL Server 2014 Developer (64 bit) on Windows Server. When you enter the Logging options, you receive the following error message:

Log provider "Microsoft.LogProviderSQLServer" is not installed correctly on this computer. (Microsoft Visual Studio)
===================================

Log provider "Microsoft.LogProviderSQLServer" is not installed correctly on this computer. (Microsoft Visual Studio)

------------------------------
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=LogProviderNotInstalled&LinkId=20476

------------------------------
Program Location:

   at Microsoft.DataTransformationServices.Design.DtsBasePackageDesigner.GetLogProviderInfo(String creationName, IServiceProvider serviceProvider)
   at Microsoft.DataTransformationServices.Design.LogProviderDesigner.get_LogProviderUI()
   at Microsoft.DataTransformationServices.Design.LoggingOptionsEditor.AddRow(LogProvider prov)

When you receive the error message, you can delete the existing log configuration and add a new configuration. However, because of this issue, it doesn't retain the setting. Moreover, this issue occurs every time you re-open the package and look at the logging settings.

↑ Back to the top


Cause

This is a known issue in the products listed in the "Applies To" section. Microsoft is investigating the issue and will provide more information as it becomes available.

↑ Back to the top


Keywords: kb

↑ Back to the top

Article Info
Article ID : 3150780
Revision : 1
Created on : 1/7/2017
Published on : 4/21/2016
Exists online : False
Views : 418