Issue: Cannot See Execute Package Option for SSIS Package in SQL Server Business Intelligence Development Studio (BIDS)
Everyone working on SQL Server and its components (SSIS, SSAS & SSRS) would require Business Intelligence Development Studio (BIDS) which is a really cool integrated development environment allowing us to work on different types of projects simultaneously like SSIS, SSAS & SSRS (All in One Solution). I came across an issue with the SSIS project, in which there was no option to execute the package.
Recently one of the developers in my team came to me complaining that while he was working on an SSIS package, he was unable to see the execute package option when he right clicked on the package in Solution Explorer in BIDS. When I took a look at his Visual Studio / BIDS, I found that some of the settings were messed up and the settings did not seemed to be same as that of a standard BIDS environment due to which the execute package option was not available in the solution explorer.
To fix this issue or in general to reset all the settings of BIDS to bring it to a state same as that of a new installation, follow the below steps:
- Open Business Intelligence Development Studio (BIDS).
- Go to Tools menu and select Import and Export Settings….
- This will bring up the Import and Export Settings Wizard window, Select Reset all settings option and click Next in the Welcome to the Import and Export Settings Wizard page.
Note: You can use this step / page to even export your custom settings to some other environment or import your settings from a different environment by selecting appropriate options.
In the Save Current Settings page of the wizard, select Yes (Recommended) to save the current settings so that it can be used to get back to the previous state in case if you want to revert back to the old settings of if something goes wrong in this process, Else you can may select No if you dont want to save the current settings and click on Next.
Choose Business Intelligence Settings in the Choose a Default Collection of Settings page of the wizard and click Finish and then click Close once the BIDS settings are successfully reset.
This simple procedure can be used to do one of the following things:
Export customized BIDS settings to a different server / environment.
Import customized BIDS settings from a different server / environment.
Reset all the customized BIDS settings to bring it back to the original state as that of a new installation.