http://blogs.msdn.com/akfaulkner/archive/2006/09/20/763967.aspxSome of you might wonder, how do I debug the Data Warehouse Import Tasks? There are two options: Perform a Sql Trace against the Data Warehouse database. Run the Data Warehouse debug server. The debug server is a utility which allows you to see traceenCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/akfaulkner/archive/2006/09/20/763967.aspx#1980293Wed, 28 Mar 2007 23:58:26 GMT91d46819-8472-40ad-a661-2c78acb4018c:1980293Leia<p>When should I run the debug server? &nbsp;With the DTS task running?</p> <p>Thanks,</p> <p>Leia</p> http://blogs.msdn.com/akfaulkner/archive/2006/09/20/763967.aspx#1980391Thu, 29 Mar 2007 00:15:18 GMT91d46819-8472-40ad-a661-2c78acb4018c:1980391akfaulkner<p>Yes, Start the debug server before executing the DTS tasks and stop the debug server after all the DTS tasks are complete.</p> <p>Hope this helps.</p> <p>Alan</p> http://blogs.msdn.com/akfaulkner/archive/2006/09/20/763967.aspx#8564155Fri, 30 May 2008 22:59:10 GMT91d46819-8472-40ad-a661-2c78acb4018c:8564155Derrick Lau<p>Thanks! &nbsp;This blog helped alot!</p>