Giter VIP home page Giter VIP logo

bideveloperextensions / bideveloperextensions Goto Github PK

View Code? Open in Web Editor NEW
87.0 18.0 24.0 144.05 MB

A Visual Studio extension that enhances development functionality in Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDT).

Home Page: https://bideveloperextensions.github.io

License: Other

PowerShell 2.63% C# 94.79% XSLT 0.48% Smalltalk 0.77% NSIS 1.18% Batchfile 0.15%
ssdt bids-helper sql-server-bi ssas ssrs ssis analysis-services reporting-services integration-services visual-studio-extension

bideveloperextensions's People

Contributors

dgosbell avatar furmangg avatar sqlgreen avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

bideveloperextensions's Issues

Not show BmilExpress in menu

Hi,
i install BimlExpress but now not show "BimlExpress" in menu and not exists in "Extensions and update" list

Fresh install BIML Features currently unavailable

I just installed the BI Developer extensions in VS 2015 Professional. After creating an Integration project I get an error when trying to add a BIML file: BIML features are currently unavailable while we wait for Varigence to provide an update to the BIMLEngine component.

Unable to find the directories containing Tasks and Data Flow Task components.

Hi
I have visual studio 2017 with an instance that has SSDT installed. I am using SQL Server 2014. I installed BI Developer Extensions, many of which work perfectly and are great. However, when I try to run the Design Warning Scanner (the feature we are most interested in), I get the error message "Unable to find the directories containing Tasks and Data Flow Task components. Check the integrity of your installation." There are additional error message notifications from .net below, but it's in a messagebox so I can't copy them from the message. See the image below. We tried looking this error up in Google, and after a couple of hours of failed attempts to find a solution, we're hoping you can help us resolve this issue. We are very eager to use the Design Warning Scanner! Thank you so much for this great utility!!

image

Tabular Actions Editor shows error about AdomdClient

In VS2017 SSDT with nothing else installed, Tabular Actions Editor doesn't launch. It is using the Microsoft.AnalysisServices.AdomdClient rather than the AppLocal version. Consider changing it to use AppLocal.

Usage based optimization failing

I used to have an older version of BIDS Helper. Then I updated my Visual studio to version 2017 (15.5.6). In this new VS my Usage Based Optimization is not working for multidimensional cube. See the detailed error below. I found online that it must be because of missing BIDS file. So I have installed the latest version of BI Developer Extensions (2.1.1) from GitHub. I've got some other functions working. Like, for example, Edit Aggregations or Update All Estimated Counts. But the Aggregations tab remained unchanged. I don't get the additional toolbar buttons. And Usage Based Optimization keeps giving the same error. I do have additional toolbar buttons on other tabs of Cube Design window.

===================================

The system cannot locate the object specified.
(Microsoft Visual Studio)


Program Location:

at EnvDTE.IVsExtensibility.RunWizardFile(String bstrWizFilename, Int32 hwndOwner, Object[]& vContextParams)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.RunAddNewItemWizard(String pszItemName, Int32 cFilesToOpen, String[] rgpszFilesToOpen, IntPtr hwndDlg)
at Microsoft.DataWarehouse.VsIntegration.Shell.Project.FileProjectHierarchy.RunWizard(String wizardName, String newItemName)
at Microsoft.DataWarehouse.DataWarehouseUtilities.RunWizard(String wizardName, IServiceProvider serviceProvider, Object[] stackParameters)
at Microsoft.AnalysisServices.Design.AnalysisServicesUtilities.InvokeUsageBasedOptimizationWizard(MeasureGroup measureGroup, Partition[] selectedPartitions)
at Microsoft.AnalysisServices.Design.Aggregations.AggregationsEditor.OnUBO(MenuCommand menuCommand, CommandHandlingArgs args)

Cannot Install - Options Window Error

Summary
The package installs without any errors. After restarting, the package is not available, and the options windows has errors.

System Information

Microsoft Visual Studio Professional 2015
Version 14.0.25420.01 Update 3
Microsoft .NET Framework
Version 4.7.02053

Installed Version: Professional

LightSwitch for Visual Studio 2015 00325-60004-60233-AA429
Microsoft LightSwitch for Visual Studio 2015

Visual Basic 2015 00325-60004-60233-AA429
Microsoft Visual Basic 2015

Visual C# 2015 00325-60004-60233-AA429
Microsoft Visual C# 2015

Visual C++ 2015 00325-60004-60233-AA429
Microsoft Visual C++ 2015

Visual F# 2015 00325-60004-60233-AA429
Microsoft Visual F# 2015

Windows Phone SDK 8.0 - ENU 00325-60004-60233-AA429
Windows Phone SDK 8.0 - ENU

ASP.NET and Web Tools 2015.1 (Beta8) 14.1.11107.0
ASP.NET and Web Tools 2015.1 (Beta8)

ASP.NET Web Frameworks and Tools 2012.2 4.1.41102.0
For additional information, visit http://go.microsoft.com/fwlink/?LinkID=309563

ASP.NET Web Frameworks and Tools 2013 5.2.40314.0
For additional information, visit http://www.asp.net/

BI Developer Extensions for Visual Studio 2015 2.1.1
BI Developer Extensions v2.1.1 for Visual Studio 2015 - An add-in to extend SQL Server Data Tools

Common Azure Tools 1.8
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

JavaScript Language Service 2.0
JavaScript Language Service

JavaScript Project System 2.0
JavaScript Project System

Microsoft Azure Mobile Services Tools 1.4
Microsoft Azure Mobile Services Tools

NuGet Package Manager 3.4.4
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

Office Developer Tools for Visual Studio 2015 ENU 14.0.23025
Microsoft Office Developer Tools for Visual Studio 2015 ENU

PreEmptive Analytics Visualizer 1.2
Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.

SQL Server Data Tools 14.0.60519.0
Microsoft SQL Server Data Tools

Telerik ASP.NET AJAX VSExtensions 2017.3.906.0
Progress® Telerik® UI for ASP.NET AJAX Visual Studio extensions

Telerik ASP.NET Core VSExtensions 2017.3.1017.0
Progress® Telerik® UI for ASP.NET Core Visual Studio extensions

Telerik ASP.NET MVC VSExtensions 2017.3.1017.0
Progress® Telerik® UI for ASP.NET MVC Visual Studio extensions

Telerik Reporting
For more information please visit http://www.telerik.com/reporting. Copyright © 2005–2018 Telerik AD

TypeScript 1.8.34.0
TypeScript tools for Visual Studio

Workflow Manager Tools 1.0 1.0
This package contains the necessary Visual Studio integration components for Workflow Manager.

Here is the error message

BIDS Helper encountered an error when Visual Studio started:
Could not load file or assembly 'Microsoft.DataWarehouse' or one of its dependencies. The system cannot find the file specified.
at System.Reflection.RuntimeAssembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, RuntimeAssembly locationHint, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoadAssemblyName(AssemblyName assemblyRef, Evidence assemblySecurity, RuntimeAssembly reqAssembly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean throwOnFileNotFound, Boolean forIntrospection, Boolean suppressSecurityChecks)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean forIntrospection)
at System.Reflection.RuntimeAssembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
at System.Reflection.Assembly.Load(String assemblyString)
at BIDSHelper.Core.VersionInfo.get_SqlServerVersion() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\Core\VersionInfo.cs:line 94
at BIDSHelper.BIDSHelperPackage.SwitchVsixManifest() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\BidsHelperPackage.cs:line 244
at BIDSHelper.BIDSHelperPackage.Initialize() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\BidsHelperPackage.cs:line 109

Shown as installed but not working

I installed the BI developer extension on my VS 2017 installation. It shows as installed
image
...but I'm not able to add BIML file in an SSIS project, I get this error:
image
When I tried to install by executing the visx installer, I get an error. Here's the error and error log.
image

System specs:

  • Win 10 x64 Enterprise
  • Visual studio 2017 Professional and Enterprise instances
  • SQL Server 2017 Enterprise
  • SSDT 2017
  • Lots of space in C drive and lots of RAM left.

If this is not an issue, how can I resolve it?

Issue During Installation

Hi there! I am trying to install the SQL BI Developer Extensions in VS 2017, (Downloaded from the 'Extensions & Updates', and I am getting an error stating that prerequisites are required. It doesn't provide any further information. Any idea what that I may need? Thanks!
issue

Cannot Remove BIDSHelper

Hi, I installed the BIDSHelper VS add-on for VS2015 and it started causing my VS to lock up every time I right-clicked in solution explorer. So, I attempted to remove it first using the extensions manager (which didn't remove it completely) then actually trying to hunt down all the different components and manually deleting them. There are apparently still some components left on my machine and they are still causing VS to screw up. This is the case even after I've done a complete reinstall of VS. Please advise exactly where you install all these components and how you register them with VS so I can truly remove your software from my computer.

Thank you. -yl

How to sync definitions for role playing dimensions

I am trying to sync definitions on a role playing dimension and I get an error when I do that. The main dimension from which the role playing dimension was created has the definitions synced using "Sync Definitions" and now I want to propagate the definitions to the role playing dimensions and that is when I get the error. I am not sure how I need to go about getting this done.

image

Failure to start after installing in VS2017

VS 2017 Pro
Version 15.8.5 VisualStudio.15.Release/15.8.5+28010.2036
Microsoft .NET Framework Version 4.7.02556

After installation, nothing from the extension appeared to have loaded. In Tools|Options|BIDS Helper|Version, get the following error information:

BIDS Helper encountered an error when Visual Studio started:
BIDS Helper encountered an error when Visual Studio started:
Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
at System.Reflection.RuntimeModule.GetTypes(RuntimeModule module)
at System.Reflection.RuntimeModule.GetTypes()
at System.Reflection.Assembly.GetTypes()
at BIDSHelper.BIDSHelperPackage.Initialize() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\BidsHelperPackage.cs:line 120
Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

Could not load file or assembly 'Microsoft.DataTransformationServices.VsIntegration, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

BIDS Helper encountered an error when Visual Studio started:
BIDS Helper plugin constructor failed on TabularHideMemberIfPlugin: Exception has been thrown by the target of an invocation.
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at BIDSHelper.BIDSHelperPackage.Initialize() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\BidsHelperPackage.cs:line 154

Inner exception:
Exception has been thrown by the target of an invocation.
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at BIDSHelper.BIDSHelperPackage.Initialize() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\BidsHelperPackage.cs:line 154
Inner exception:
Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
at BIDSHelper.TabularHideMemberIfPlugin..ctor(BIDSHelperPackage package)BIDS Helper encountered an error when Visual Studio started:
BIDS Helper plugin constructor failed on TriStatePerspectivesPlugin: Exception has been thrown by the target of an invocation.
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at BIDSHelper.BIDSHelperPackage.Initialize() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\BidsHelperPackage.cs:line 154

Inner exception:
Exception has been thrown by the target of an invocation.
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at BIDSHelper.BIDSHelperPackage.Initialize() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\BidsHelperPackage.cs:line 154
Inner exception:
Could not load file or assembly 'Microsoft.AnalysisServices.Design, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
at BIDSHelper.TriStatePerspectivesPlugin.OnWindowActivated(Window GotFocus, Window LostFocus)
at BIDSHelper.BIDSHelperWindowActivatedPluginBase.OnEnable() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\Core\BIDSHelperWindowActivatedPluginBase.cs:line 104
at BIDSHelper.Core.BIDSHelperPluginBase..ctor(BIDSHelperPackage package) in C:\projects\BIDS Helper\GitHub\bideveloperextensions\Core\BIDSHelperPluginBase.cs:line 45
at BIDSHelper.TriStatePerspectivesPlugin..ctor(BIDSHelperPackage package) in C:\projects\BIDS Helper\GitHub\bideveloperextensions\SSAS\TriStatePerspectivesPlugin.cs:line 24BIDS Helper encountered an error when Visual Studio started:
BIDS Helper plugin constructor failed on TabularSyncDescriptionsPlugin: Exception has been thrown by the target of an invocation.
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at BIDSHelper.BIDSHelperPackage.Initialize() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\BidsHelperPackage.cs:line 154

Inner exception:
Exception has been thrown by the target of an invocation.
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at BIDSHelper.BIDSHelperPackage.Initialize() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\BidsHelperPackage.cs:line 154
Inner exception:
Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
at BIDSHelper.SSAS.TabularSyncDescriptionsPlugin..ctor(BIDSHelperPackage package)

ssas tabular 2012

I installed version 1.7.0.0 but am not seeing BIDS helper when I open up by cube? I want to move fields around in the display folders.

Version.docx

Expression and Configuration Highlighter SSDT 15.8.2

I just upgraded from SSDT 15.7.1 to 15.8.2 (using VS 2017), and the "Expression and Configuration Highlighter" isn't visible on the connection managers(that are using package configurations) in SSIS anymore. I am developing for SQL 2016.

SSAS Tabular 1200: Printer Friendly Dimension Usage enhancements

BI Developer Extensions has support for basic Printer Friendly Dimension Usage reports against 1200 Tabular models. But it doesn't account for bi-directional relationships or any more advanced relationship types. For example, it would be nice to show m2m (infinity) symbols in the bus matrix version of the report.

SSRS project error when running used or unused report datasets command

Attached error occurs on 1st RDL of any SSRS project when running used or unused report datasets command

Visual studio environment

Microsoft Visual Studio Community 2015
Version 14.0.25431.01 Update 3
Microsoft .NET Framework
Version 4.7.02558

Installed Version: Community

Microsoft Visual Studio Tools for Applications 2015 00322-20000-00000-AA266
Microsoft Visual Studio Tools for Applications 2015

Visual Basic 2015 00322-20000-00000-AA266
Microsoft Visual Basic 2015

Visual C# 2015 00322-20000-00000-AA266
Microsoft Visual C# 2015

Visual C++ 2015 00322-20000-00000-AA266
Microsoft Visual C++ 2015

Application Insights Tools for Visual Studio Package 7.0.20622.1
Application Insights Tools for Visual Studio

ASP.NET and Web Tools 2015.1 (Beta8) 14.1.11107.0
ASP.NET and Web Tools 2015.1 (Beta8)

ASP.NET Web Frameworks and Tools 2012.2 4.1.41102.0
For additional information, visit http://go.microsoft.com/fwlink/?LinkID=309563

ASP.NET Web Frameworks and Tools 2013 5.2.40314.0
For additional information, visit http://www.asp.net/

BI Developer Extensions for Visual Studio 2015 2.1.1
BI Developer Extensions v2.1.1 for Visual Studio 2015 - An add-in to extend SQL Server Data Tools

Common Azure Tools 1.8
Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

JavaScript Language Service 2.0
JavaScript Language Service

JavaScript Project System 2.0
JavaScript Project System

Microsoft Azure Mobile Services Tools 1.4
Microsoft Azure Mobile Services Tools

NuGet Package Manager 3.4.4
NuGet Package Manager in Visual Studio. For more information about NuGet, visit http://docs.nuget.org/.

PreEmptive Analytics Visualizer 1.2
Microsoft Visual Studio extension to visualize aggregated summaries from the PreEmptive Analytics product.

SQL Server Analysis Services 14.0.1012.227
Microsoft SQL Server Analysis Services Designer
Version 14.0.1012.227

SQL Server Data Tools 14.0.61709.290
Microsoft SQL Server Data Tools

SQL Server Integration Services
Microsoft SQL Server Integration Services Designer
Version 14.0.800.90

SQL Server Reporting Services 14.0.1012.227
Microsoft SQL Server Reporting Services Designers
Version 14.0.1012.227

TypeScript 1.8.36.0
TypeScript tools for Visual Studio

Add Annotations to Calculation Properties (SSAS Multidimensional)

In VS2015 the "Calculation Properties" window allows to edit "Display Folder", "Associated Measure Group" and "Description". Please add the possibility to add/edit Annotations.
SMO class Microsoft.AnalysisServices.CalculationProperty has member Annotations, so adding it to Calculation Properties window should be possible.

Tabular Actions Editor not showing in VS2017 v2.1.1

I just installed BI Dev Ext for VS2017, right clicked the .BIM file but Tabular actions Editor is not showing.

Is this a bug? Is there another way to access the Actions editor?

Need to modify drillthrough query, please help.

Mike

Sortable Package Properties report missing from solution menu

Reinstalled Visual Studio and BIDS Helper on new machine. Sortable Package Properties Report is now missing from solution menu (it is still on project menu). Versions are 12.0.21005.1 of Visual Studio and 2014 Version 1.7.0.0 of BIDS Helper.

SSIS/BIML: Script Transformation writing to a Blob Column

Cannot write data to a BlobColumn from a ScriptComponentProject when generating a package using BIML.

Row.ColumName1.AddBlobData(enc.GetBytes(mystr.ToString()));

Results in error: "'string' does not contain a definition for 'GetBlobData' and no extension method 'GetBlobData' accepting a first argument of type 'string' could be found"

Option for SSAS Display Folders Not Showing

I have Visual Studio 2017 15.8.7 and SSDT 15.1.61808.07020. When navigating to a Tabular Model, I no longer see the option to configure Display Folders. This was working prior to the update of Visual Studio.

image

In SSIS.ResetGUID do not touch project connection managers

I'm trying to get up a build environment to do some work but until I can submit a pull we need to add a check to see if the connection manager scope is package and not project.

DTSConnectionManagerScope Enum
https://docs.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.dts.runtime.dtsconnectionmanagerscope?view=sqlserver-2017

ConnectionManager.Scope Property
https://docs.microsoft.com/en-us/dotnet/api/microsoft.sqlserver.dts.runtime.connectionmanager.scope?view=sqlserver-2017#Microsoft_SqlServer_Dts_Runtime_ConnectionManager_Scope

Smart Diff not working in v2.2.0.0 (Smart Diff requires SSAS extension in SSDT to be installed)

Hi, just installed v 2.2.0.0 and tried Smart Diff.

When attempting to use SmartDiff, I get:
Could not load file or assembly 'Microsoft.AnalysisServices.Backedn, Version 15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

This happens if I use the Default VS DIff View, or a third party command line viewer, vsdiff.exe.

I get this message in VS Options | BIDS Helper | Version:

BIDS Helper encountered an error when Visual Studio started:
BIDS Helper encountered an error when Visual Studio started:
Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
at System.Reflection.RuntimeModule.GetTypes(RuntimeModule module)
at System.Reflection.RuntimeModule.GetTypes()
at System.Reflection.Assembly.GetTypes()
at BIDSHelper.BIDSHelperPackage.Initialize() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\BidsHelperPackage.cs:line 120
Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Fusion Log:
WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

BIDS Helper encountered an error when Visual Studio started:
BIDS Helper plugin constructor failed on TabularHideMemberIfPlugin: Exception has been thrown by the target of an invocation.
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at BIDSHelper.BIDSHelperPackage.Initialize() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\BidsHelperPackage.cs:line 154

Inner exception:
Exception has been thrown by the target of an invocation.
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at BIDSHelper.BIDSHelperPackage.Initialize() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\BidsHelperPackage.cs:line 154
Inner exception:
Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
at BIDSHelper.TabularHideMemberIfPlugin..ctor(BIDSHelperPackage package)BIDS Helper encountered an error when Visual Studio started:
BIDS Helper plugin constructor failed on TabularSyncDescriptionsPlugin: Exception has been thrown by the target of an invocation.
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at BIDSHelper.BIDSHelperPackage.Initialize() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\BidsHelperPackage.cs:line 154

Inner exception:
Exception has been thrown by the target of an invocation.
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at BIDSHelper.BIDSHelperPackage.Initialize() in C:\projects\BIDS Helper\GitHub\bideveloperextensions\BidsHelperPackage.cs:line 154
Inner exception:
Could not load file or assembly 'Microsoft.AnalysisServices.Common.FrontEnd, Version=15.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
at BIDSHelper.SSAS.TabularSyncDescriptionsPlugin..ctor(BIDSHelperPackage package)

BIML Features Not Available

"BIML Features are currently unavailable while we wait for Varigence to provide an update to the BimlEngine component."

Any ETA on when this will be available?

I wanted to use VS 2017 and BIML Express doesn't support it either.

SSIS: expression editor error when package is in debug mode

Run a package to completion. Then open the variables window and edit the expression on a variable using the BIDS Helper expression editor. Save the change and you get an error message:

Catastrophic failure
at BIDSHelper.SSIS.SSISHelpers.MarkPackageDirty(Package package) line 45

Unable to save Tabular Display Folders

When I try adding a folder and then save, I am getting a weird error like below.

Method not Found: System.Collections.Generic.IEnumerable`1<System.String>Microsoft.AnalysisServices.BackEnd/SandboxTransaction.Commit() at BIDSHelper.SSAS.TabularDisplayFolderPlugin

Also, I am getting the same error when I try creating a new action. Is this some kind of a known issue?

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.