• I work with Tom and the "stovepipe" problem is something I've seen here as well as other places. Having projects like this centralized, even with a steering committee of one can help to prevent inconsistencies.

    Also, a good look at some of the pitfalls. ETL is a great tool, but not the solution for bad data.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    http://www.dkranch.net