Something like Visio diagrams does the trick.

It is suggested you visually diagram out all your ETL packages - so it can
help you visualize your data movement and help with actual design of the ETL
packages.

Sounds like this process would help get you what you want albeit it's after
the project instead of early on in development.

"YesGoGoGo" <YesGoGoGo@gmail.com> wrote in message
news:1190266996.803505.306990@i38g2000prf.googlegr oups.com...
> hi!
> I join a datawarehouse project which already run in 2 years.
> There is few document left,so I can't see the whole picture of the
> project and data movement.
> Now I've tried to trace these data movement and keep it in record.
> I wonder if there is a helpful tool could manage these data movement.
>
> My project use MS SQL 2005.
>
> need some suggestion.
> thanks a lot!
>