Monthly Archives: January 2008

New Tool to Help With Partitioned Tables

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 … Continue reading

Posted in Uncategorized | Comments Off on New Tool to Help With Partitioned Tables

Handling Multiple Errors in SSIS Revisited

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 … Continue reading

Posted in Uncategorized | Comments Off on Handling Multiple Errors in SSIS Revisited

Resetting the View in the SSIS Designer

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 … Continue reading

Posted in Uncategorized | Comments Off on Resetting the View in the SSIS Designer