-
Notifications
You must be signed in to change notification settings - Fork 10
Install BIDS Helper
Previous Install MDX Studio | Manual Install | Install DTS Designer Next |
---|
FineBuild can install and configure the BIDS Helper as part of the SQL Server install process. If you do not want to include BIDS Helper in your FineBuild install, then do not download it.
BIDS Helper was written by Darren Gosbell (a SQL Server MVP specialising in SSIS) et al, and is now called BI Developer Extensions. It was chosen to be included in FineBuild because it adds extensive functionality to developers of SSIS packages.
If you install Business Intelligence Development Studio or Install SSDT-BI it is recommended that you also install BI Developer Extensions.
The new location for BI Developer Extensions is https://bideveloperextensions.github.io/
Item | Location |
---|---|
BIDS Helper home page | https://bideveloperextensions.github.io/ |
BIDS Helper download | For SQL 2012 and above: https://bideveloperextensions.github.io/downloads/ For SQL 2005 to SQL 2008 R2: https://github.com/BIDeveloperExtensions/bideveloperextensions/releases/tag/v1.7.0 |
BIDS Helper Wikipedia entry | https://en.wikipedia.org/wiki/BIDS_Helper |
BIDS Helper introduction | http://siddhumehta.blogspot.com/2009/07/ssis-performance-ssis-debugging-ssis.html |
Automated silent installation of BIDS Helper is performed by Process Id 4BC and is controlled by the parameters below:
SQL Version | Parameter | FULL Build | WORKSTATION Build | CLIENT Build |
---|---|---|---|---|
SQL2019 | /SetupBIDSHelper: | N/A | N/A | N/A |
/SetupSQLTools: | No | Yes | Yes | |
SQL2017 | /SetupBIDSHelper: | N/A | N/A | N/A |
/SetupSQLTools: | No | Yes | Yes | |
SQL2016 | /SetupBIDSHelper: | N/A | N/A | N/A |
/SetupSQLTools: | No | Yes | Yes | |
SQL2014 | /SetupBIDSHelper: | N/A | N/A | N/A |
/SetupSQLTools: | No | Yes | Yes | |
SQL2012 | /SetupBIDSHelper: | N/A | N/A | N/A |
/SetupSQLTools: | No | Yes | Yes | |
SQL2008R2 | /SetupBIDSHelper: | Yes | Yes | Yes |
/SetupSQLTools: | No | Yes | Yes | |
SQL2008 | /SetupBIDSHelper: | Yes | Yes | Yes |
/SetupSQLTools: | No | Yes | Yes | |
SQL2005 | /SetupBIDSHelper: | Yes | Yes | Yes |
/SetupSQLTools: | No | Yes | Yes |
In order to maintain compatibility with older versions of SQL FineBuild, the parameters /InstBIDSHelper: and /InstSQLTools: can also be used.
BIDS Helper will only be installed if you also install BIDS or SSDT. It will be installed with CLIENT and WORKSTATION builds, but not with a FULL build. If you want to install it with a FULL build, the following parameter should be added at run time:
/SetupSQLTools:Yes
For SQL2012 and above, the BI Developer Extensions component should be downloaded from the Visual Studio Marketplace. Therefore no install of this component is offered in SQL FineBuild for these releases of SQL Server.
FineBuild also uses the following parameters to help install BIDS Helper:
Parameter | SQL Version | Default Value | Description |
---|---|---|---|
/BIDSexe: | SQL 2008R2 | BIDSHelper2008Setup(1.7.0.0).exe | Name of BIDS Helper install file |
/BIDSexe: | SQL 2008 | BIDSHelper2008Setup(1.7.0.0).exe | Name of BIDS Helper install file |
/BIDSexe: | SQL 2005 | BIDSHelper2005Setup(1.7.0.0).exe | Name of BIDS Helper install file |
The FineBuild install for BIDS Helper includes the following:
- Perform a BIDS Helper install
The following steps show what you would have to do to install BIDS Helper manually. FineBuild does all of this work for you automatically.
-
Navigate to the Additional Components folder
Double-click on BIDS Helper
Platform File SQL 2008R2 Use BIDSHelper2008Setup(1.7.0.0).exe SQL 2008 Use BIDSHelper2008Setup(1.7.0.0).exe SQL 2005 Use BIDSHelper2005Setup(1.7.0.0).exe The screenshots below show an older release, but the install process is much the same for all releases
-
The BIDS Helper setup window is displayed
Click Next to continue
-
Accept the License Agreement
Click Next to continue
-
Accept the Install Location
Click Next to continue
-
The BIDS helper install runs, then the completion window is displayed
Click Finish to end
The BIDS Helper components will register automatically the first time that the SQL Server Business Intelligence Development Studio (BIDS) is run
Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements
Previous Install MDX Studio | Top | Install DTS Designer Next |
---|
Key SQL FineBuild Links:
SQL FineBuild supports:
- All SQL Server versions from SQL 2019 through to SQL 2005
- Clustered, Non-Clustered and Core implementations of server operating systems
- Availability and Distributed Availability Groups
- 64-bit and (where relevant) 32-bit versions of Windows
The following Windows versions are supported:
- Windows 2022
- Windows 11
- Windows 2019
- Windows 2016
- Windows 10
- Windows 2012 R2
- Windows 8.1
- Windows 2012
- Windows 8
- Windows 2008 R2
- Windows 7
- Windows 2008
- Windows Vista
- Windows 2003
- Windows XP