How to integrate BIDS with TFS 2010

This is an outline of the steps that are required to integrate BIDS with TFS 2010. This link contains the detailed steps of what to do, with links to the necessary download sites:

http://arcanecode.com/2012/02/14/using-tfs2010-with-visual-studio-bids-2008-and-sql-server-management-studio/

1. Download VS 2008 SP1 to a suitable place and install it as per step 1 in the link.
2. Download and install VS 2008 Team Explorer as per step 2. (This is an ISO so you'll need to extract this to a suitable place and install from there.)
3. Reinstall VS 2008 SP1. (I have not yet encountered the error described in the article at this point.)
4. Download and install VS Team System 2008 SP1 Forward Compatibility Update for TFS 2010.
5. Reboot.
6. Open BIDS, go to Tools > Connect to Team Foundation Server and connect to the TFS server.

log4net not logging to SQL Server table

By design, log4net silently fails if there are any configuration problems preventing it logging to the desired output.  To troubleshoot configuration problems, enable log4net internal debugging as described in the log4net support site FAQs.

Excel 2010 unable to open file created by ExcelLibrary

This post documents a workaround for a bug in ExcelLibrary. If you create a file of size less than 7KB, Excel 2010 is unable to open the file. To solve this, prepopulate the worksheet with at least 200 rows containing empty cells.

for (int rowIndex = 0; rowIndex < 200; rowIndex++)
{
    sheet.Cells[rowIndex, 0] = new Cell(string.Empty);
}