Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Great Post on Clearing all data from your Data Warehouse

Hey there Gang !


 Most of you probably know Jamie Thompson has move his blog over to 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 -

Keep up the good work Jamie ! 


Posted by Jamie Thomson on 9 September 2009

Thanks Adam, I appreciate the link :)

Posted by on 9 September 2009

Great post Jamie/Adam.  I look forward to trying it out.

Leave a Comment

Please register or log in to leave a comment.