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