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 relational engine to SQL2005 and making the DTS2000…

5

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 no match in the reference table to a separate output…

4