Skip to content

Install BIDS Helper

EdVassie edited this page Mar 26, 2021 · 1 revision
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

FineBuild BIDS Helper Install

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

Top


Manual 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.

  1. 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

    Explorer

  2. The BIDS Helper setup window is displayed

    Click Next to continue

    Welcome

  3. Accept the License Agreement

    Click Next to continue

    License

  4. Accept the Install Location

    Click Next to continue

    Install Location

  5. 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

    Complete

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
Clone this wiki locally