bideveloperextensions icon indicating copy to clipboard operation
bideveloperextensions copied to clipboard

SSIS deploy unavailable in VS 16.7.2

Open jbaynhamuk opened this issue 3 years ago • 3 comments

Since upgrading VS19 to 16.7.2, I am now unable to see the BIDS Helper deploy configuration options in the project properties screen or deploy packages as before.

BIDS version is 2.4.0, and it appears in the About page. The Deploy SSIS option is set to True.

SSDT version is 16.0.62008.03130.

In the version node of the BIDS options I see this error:

BIDS Helper encountered an error when Visual Studio started: 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.OriginalInitialize() in C:\projects\BIDS Helper\GitHub\bideveloperextensions2\BidsHelperPackage.cs:line 341

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.OriginalInitialize() in C:\projects\BIDS Helper\GitHub\bideveloperextensions2\BidsHelperPackage.cs:line 341 Inner exception: Method not found: 'Void Microsoft.AnalysisServices.Design.Scripts..ctor(Microsoft.AnalysisServices.Cube)'. at BIDSHelper.BIDSHelperWindowActivatedPluginBase.OnEnable() in C:\projects\BIDS Helper\GitHub\bideveloperextensions2\Core\BIDSHelperWindowActivatedPluginBase.cs:line 112 at BIDSHelper.Core.BIDSHelperPluginBase..ctor(BIDSHelperPackage package) in C:\projects\BIDS Helper\GitHub\bideveloperextensions2\Core\BIDSHelperPluginBase.cs:line 47 at BIDSHelper.TriStatePerspectivesPlugin..ctor(BIDSHelperPackage package) in C:\projects\BIDS Helper\GitHub\bideveloperextensions2\SSAS\TriStatePerspectivesPlugin.cs:line 40

I have tried an uninstall/reinstall cycle.

Thanks, J

jbaynhamuk avatar Sep 09 '20 09:09 jbaynhamuk

Check the versions in the help about page with the supported versions in the table at the bottom of the downloads page it's possible that some of your components are not up to date.

dgosbell avatar Sep 09 '20 09:09 dgosbell

All looks OK to me, SSAS 2.9.13, SSRS 2.6.7, SSIS 3.9

Thanks for the quick reply!

jbaynhamuk avatar Sep 09 '20 10:09 jbaynhamuk

Anything else I can try/check?

jbaynhamuk avatar Sep 15 '20 09:09 jbaynhamuk

We've published an updated release of BI Developer Extensions for Visual Studio 2019 that resolves this issue. Please note the compatible SSAS/SSIS/SSRS extension version.

furmangg avatar Mar 12 '23 21:03 furmangg