Try using BI Documenter. It's not for free, but it can handle the things you want.

I'm using Reporting Services 2005

Harold,

Have you ever heard of BI Documenter? http://www.bidocumenter.com/

That's a tool you can use to document your SSIS Packages.

Kindest Regards,

Jos Haemers

Jeff,

I've posted a CREATE script for the facttable with a few records. I can't post any queries because there an no queries yet. In the future the customer wants to...

Robert,

Thanks for your answer. I'm going to try to use partitioning with the help of a dba.

I've tried to fix it with use of the import export wizard, but I still didn't succeed. When running the package made by the wizard, the first task is succesfull...