Subscribe to this blog
Briefcase
Print
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 !
Posted by Jamie Thomson on 9 September 2009
Thanks Adam, I appreciate the link :)
Posted by knight_devin@hotmail.com on 9 September 2009
Great post Jamie/Adam. I look forward to trying it out.