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

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
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)



Anonymous 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
New Comments to this post are disabled

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