August 2005 - Posts

• DTS/SSIS and debugging mysterious relational engine deadlocks

  Over the last few days I've learnt a lot in how to debug SQL hangs thanks to Sunil from the SQL Server engine team. For one of the customers last week, the problem seemed to be that their DTS2000 package worked great with SQL2000. However, upgrading the Read More... Posted Monday, August 15, 2005 5:59 PM by Ashvini Sharma [MSFT] | 4 Comments

• SSIS: Handling lookup misses

  It's typical in data warehouse loads to have lookups that go against dimension tables. If the key doesn't exist, either a new one is created, or a default value is used. There're two ways to do this: 1. Lookup is configured to redirect rows that have Read More... Posted Thursday, August 04, 2005 2:21 PM by Ashvini Sharma [MSFT] | 4 Comments