BI Thoughts and Theories

Stuart Ozer on the SQL Server Customer Advisory Team (CAT) has posted a new tool to CodePlex to help with the management of "staging" tables for swapping data in and out of partitioned tables. Since this is a common scenario in data warehousing Read More...

Previously, I posted about how multiple errors in SSIS can be combined into a single unit for emailing or logging. Recently, a thread on the MSDN forums pointed out that the example wasn't quite complete. While it does show how to collect all the error Read More...

There's a minor annoyance in SSIS with the way the diagram of the package is saved. If you've ever spent time working in a package with a lot of objects, you've probably encountered it. You move some objects around, save the package, close it, then reopen Read More...