THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help

Home

Blogs

Downloads

Opml

SQLBI - Marco Russo

SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server

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 09, 2007 1:34 AM by Marco Russo (SQLBI)

Filed under: SSIS, Integration Services

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

Comments

Adam Machanic said:

What is MS doing to improve SSIS?

Here's my rejected Connect entry:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=253500

... 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 (http://blogs.msdn.com/michen/archive/2007/06/12/ssis-backpressure-mechanism.aspx).

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

Name (required)
Your URL (optional)
Comments (required)
Remember Me?
Submit

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

Syndication

Books

Consulting Services

Modeling Papers

Public Speaking

News