posted 11/23/2009 by AdamJorgensen - Views: [1003]
Hey there Gang !
Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting since Jamie is always a great source for SSIS and BI info. I wanted to share a post of his that provides a script method for clearing your DW while leaving the foreign keys intact. This is a great option when you need to debug or are working in development mode to test load speeds, etc..
Check it out here - http://sqlblog.com/blogs/jamie_thomson/archive/2009/09/08/deriving-a-list-of-tables-in-dependency-order.aspx
Keep up the good work Jamie !