THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server.
You can follow me on Twitter: @marcorus

Long life to TableDifference

It seems that Microsoft will not improve the slow SCD component that is part of SSIS (at least, this is what I understand from this Microsoft Connect answer). This means that TableDifference has a long life because it will be useful even in SQL Server 2008.

The versione 1.2 beta of TableDifference still needs some test because there is a latent bug on blob fields processing (in some multithreading scenarios).

Published Monday, July 9, 2007 1:34 AM by Marco Russo (SQLBI)

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



cinahcaM madA said:

What is MS doing to improve SSIS?  

Here's my rejected Connect entry:

... I want to be able to split up packages into multiple files so that they're reusable and maintainable.  Apparently reuse and maintainability are not high on MS's list of "features" for SSIS :(

July 8, 2007 7:30 PM

Marco Russo (SQLBI) said:

I'd like to know what other new features they are going to put into SSIS.

I'm happy they've worked on back-pressure (

I know they also improved lookup, even if I still didn't understand how the "persistent lookup" in Katmai differs from the current Lookup in SSIS 2005.

However, I don't see new components and this is another disappointment for me.

July 9, 2007 3:36 AM

Leave a Comment


About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement