installing BIDS Helper when you compile it yourself from the source code

Topics: Standing Discussions
Coordinator
Feb 17, 2008 at 10:58 PM
Sometimes in between releases, people may decide to download the source code to get the latest pre-release features. This thread discusses installing the add-in manually.

If you have previously installed BIDS Helper, just copy the compiled DLL and the BIDSHelper.AddIn file over the previous ones. They are installed at "C:\Program Files\BIDS Helper" by default.

If you have never previously installed BIDS Helper using the installer, just copy the compiled DLL and the BIDSHelper.AddIn to the "C:\Documents and Settings\<username>\My Documents\Visual Studio 2005\Addins" directory. If you go this route, be sure to delete these files from that directory before you use the next BIDS Helper release's installer.
Coordinator
Feb 21, 2008 at 11:52 PM
The source code has three .sln files:
  • BIDSHelper.sln - VS2005 solution for SQL2005 BIDS Helper
  • VS2008_BIDSHelper.sln - VS2008 solution for SQL2005 BIDS Helper
  • SQL2008_BIDSHelper.sln - VS2008 solution for SQL2008 BIDS Helper

Make sure you open up the right solution file if you're going to compile it yourself.

For SQL2008 (CTP6 or later), the install instructions are as follows:
  • If you have previously installed BIDS Helper 2008, just copy the compiled DLL and the BIDSHelper2008.AddIn file over the previous ones. They are installed at "C:\Program Files\BIDS Helper 2008" by default.
  • If you have never previously installed BIDS Helper 2008 using the installer, just copy the compiled DLL and the BIDSHelper2008.AddIn to the "C:\Documents and Settings\<username>\My Documents\Visual Studio 2008\Addins" directory. If you go this route, be sure to delete these files from that directory before you use the next BIDS Helper release's installer.
Coordinator
Apr 10, 2011 at 5:05 AM

for info on compiling on an x64 machine, see http://bidshelper.codeplex.com/discussions/12934

Coordinator
Feb 8, 2012 at 4:21 AM

The solution files are being upgraded so that you need Visual Studio 2010 in order to compile BIDS Helper yourself. the .sln files are now:

  • SQL2005_BIDSHelper.sln - The VS2010 solution file for SQL2005 BIDS Helper.
    • Put the compiled files and BIDSHelper.AddIn to either of the following:
      • c:\users\yourusername\Documents\Visual Studio 2005\Addins
      • c:\Program Files\BIDS Helper
  • SQL2008_BIDSHelper.sln - The VS2010 solution file for SQL2008 (and SQL2008 R2) BIDS Helper
    • Put the compiled files and BIDSHelper2008.AddIn to either of the following:
      • c:\users\yourusername\Documents\Visual Studio 2008\Addins
      • c:\Program Files\BIDS Helper 2008
  • SQL2012_BIDSHelper.sln - The VS2010 solution file for SQL2012
    • Put the compiled files and BIDSHelper2012.AddIn to either of the following:
      • c:\users\yourusername\Documents\Visual Studio 2010\Addins
      • c:\Program Files\BIDS Helper 2012

Note, if you have multiple versions of SQL on the same machine, you may need to follow these instructions if you get a compile error about an indirect reference:

http://blogs.msdn.com/b/jason_howell/archive/2010/08/18/visual-studio-2010-solution-build-process-give-a-warning-about-indirect-dependency-on-the-net-framework-assembly-due-to-ssis-references.aspx