In my opinion the BI Documenter 4.0 - is the best!

Try this: http://www.pragmaticworks.com/Products/Business-Intelligence/BIDocumenter/Default.aspx

BI Documenter outputs "MSDN style" SQL Server documentation in either compiled help or HTML format. While documenting all of the major SQL Server components, BI Documenter also documents the entire BI stack, including Analysis Services (SSAS), Integration Services (SSIS), and Reporting Services (SSRS).The unique documentation snapshot feature enables archiving of historical SQL Server documentation sets. New documents can be regenerated at the touch of a button. BI Documenter also allows you to customize the look and feel of your documentation with the ability to add your own branding.

With BI Documenter, you can:

Generate complete SQL documentation at the push of a button

Document SQL Server, Analysis Services, Integration Services and Reporting Services in the same documentation set

Capture metadata snapshots for historical analysis

Output HTML Help (*.chm) or plain HTML

Use either a graphical wizard or command line interface

Document SQL Server 2008!

Tell your own story using the built-in diagramming tool

New Features of BI Documenter:

Compare Snapshots

Object Lineage/Impact Analysis

Snapshot Object filtering

Data Profiling and Recommendations

Diagram Editor Object Properties

Snapshot Creation

Also included are a host of UI and usability enhancements to increase user productivity.

Review Your Solution: page provides a tool tab navigate to key functionality instead of having to click the next button reach those features.

Snapshot Creation: exception link is provided to display a dialog to display any exceptions that were encountered during.

UI look and feel: Updated to coincide with UI look and feel like other product offerings.