I use the tool BIDocumenter, from Pragmatic Works (http://www.pragmaticworks.com)

Disclaimer : we signed up as a reseller locally.

But the reason we did is that it is an excellent tool, documenting the DB, SSIS packages, SSAS cubes, and SSRS

And also has data lineage - showing where data came from