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.
Related Articles
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:
1. Open Business Intelligence Development Studio (BIDS).
2. Go to Tools menu and select Import and Export Settings....
3. 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.
4. 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.
5. 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.
And now your BIDS should get back to the initial state same as that of a new installation. This is a simple procedure to fix any unwanted settings by resetting all your BIDS settings.
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.
This post first appeared on MyTechnoBook - Datta's Technical Notes..!!, please read the originial post: here
