Andy Leonard (1/20/2009)
Enterprise metadata is important. Unfortunately, you learn that (or you will) when something goes wrong. I wrote about using SSIS to collect enterprise metadata at http://sqlblog.com/blogs/andy_leonard/archive/2008/08/28/ssis-design-pattern-collect-enterprise-sql-server-database-metadata-with-ssis.aspx. That article was prompted by an email from someone doing what I've needed to do before: detect changes in the source system schema before it broke the ETL.:{> Andy
Andy, I don't know if it is just my computer, but a lot of the images in your article seem to be broken.