June 2006 - Posts

• A tool to improve DTS to SSIS migration

  I wrote a small tool to improve the migration from SSIS to DTS. The problem I had to solve was this: I have many Data Transform Tasks that have a simple behavior, read data from a query and write data on a table, using fast load with batch insert. You Read More... Posted Sunday, June 25, 2006 8:17 AM by Marco Russo (SQLBI) | 0 Comments

• TableDifference: a faster way to handle SCD

  I had the opportunity to test TableDifference (a component written by Alberto Ferrari ) since early versions and I can say it is a very interesting way to handle Slowly Changing Dimension (SCD) much faster than with the standard SCD component of SSIS. Read More... Posted Monday, June 12, 2006 9:20 AM by Marco Russo (SQLBI) | 0 Comments