Previous Install MDX Studio Manual Install Install DTS Designer Next

Install BIDS Helper

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 is written by Darren Gosbell (a SQL Server MVP specialising in SSIS) et al. It was chosen to be included in FineBuild because it adds extensive functionality to developers of SSIS packages using the Business Intelligence Development Studio.

BIDS Helper home page http://www.codeplex.com/bidshelper
BIDS Helper download http://www.codeplex.com/bidshelper
BIDS Helper Wikipedia entry http://en.wikipedia.org/wiki/BIDS_Helper
BIDS Helper introduction http://siddhumehta.blogspot.com/2009/07/ssis-performance-ssis-debugging-ssis.html
BIDS Helper documentation http://bidshelper.codeplex.com/documentation

FineBuild BIDS Helper Install

Automated installation of BIDS Helper is performed by Process Id 4BB and is controlled by the parameters below:

Install Parameter Build SQL2005 SQL2008 SQL2008R2 SQL2012 SQL2014
InstBIDSHelper FULL Yes Yes Yes Yes Yes
InstSQLTools No No No No No
InstBIDSHelper WORKSTATION Yes Yes Yes Yes Yes
InstSQLTools Yes Yes Yes Yes Yes
InstBIDSHelper CLIENT Yes Yes Yes Yes Yes
InstSQLTools Yes Yes Yes Yes Yes

FineBuild also uses the following parameters to help install BIDS Helper:
Prameter SQL Version Default Value Description
BIDSexe SQL 2014 BIDSHelper2012Setup(1.6.3.0).exe Name of BIDS Helper install file
BIDSexe SQL 2012 BIDSHelper2012Setup(1.6.3.0).exe Name of BIDS Helper install file
BIDSexe SQL 2008R2 BIDSHelper2008Setup(1.6.3.0).exe Name of BIDS Helper install file
BIDSexe SQL 2008 BIDSHelper2008Setup(1.6.3.0).exe Name of BIDS Helper install file
BIDSexe SQL 2005 BIDSHelper2005Setup(1.6.3.0).exe Name of BIDS Helper install file

BIDS Helper will only be installed if you also install BIDS. 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:
/InstSQLTools:Yes

The FineBuild install for BIDS Helper includes the following:
  • Perform a BIDS Helper install

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 and double-click on BIDS Helper.

SQL 2014 Use BIDSHelper2012Setup(1.6.3.0).exe
SQL 2012 Use BIDSHelper2012Setup(1.6.3.0).exe
SQL 2008R2 Use BIDSHelper2008Setup(1.6.3.0).exe
SQL 2008 Use BIDSHelper2008Setup(1.6.3.0).exe
SQL 2005 Use BIDSHelper2005Setup(1.6.3.0).exe

The screenshots below show an older release, but the install process is much the same for the current release.
BIDS Helper Explorer exe.png
2) The BIDS Helper setup window is displayed. Click Next to continue.
BIDS Helper Welcome.png
3) Accept the License Agreement. Click Next to continue.
BIDS Helper License.png
4) Accept the Install Location. Click Next to continue.
BIDS Helper Location.png
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.
BIDS Helper Complete.png
Copyright © 2011 - 2013 Edward Vassie. License and Acknowledgements
Previous Install MDX Studio Top Install DTS Designer Next

Last edited Aug 8, 2013 at 4:24 PM by EdVassie, version 37

Comments

No comments yet.