Components

ARTICLE

SSIS: living in a parallel world? Not yet…

Today I come into a nice bug (misfeature?) of SSIS 2008 and I’d like to share it with you. Let’s start from the beginning: One of the keys to make something speedy is to parallelize it. In TableDifference I read from two inputs, compare them and produce

ARTICLE

Table Difference 2.0 – Call for beta

The new version 2.0 of SSIS SCD handling component TableDifference is in beta, I am searching for beta testers and some help in writing an installer for it. You will find all the informations at www.sqlbi.eu . The final release of the component will be

ARTICLE

Table Difference 1.2

TableDifference has been updated to version 1.2. For those who want to read the main description of the component can be found here but take a look at the full story, this component and the documentaton has been updated several times. You will find complete

ARTICLE

Data Flow Components, constructors and SSIS

Yesterday I had to fix a simple still subtle bug in TableDifference , I think sharing the experience will be useful for everybody involved in custom component creation. The component has some fields that are initialized in the component constructor, at

ARTICLE

Threads and custom components: FlowSync 1.0

Several people downloaded TableDifference to handle SCD faster, some of them, especially using it on huge table (more than 10 millions rows) noticed memory problems. The problem is that of a flow running too fast and making TableDifference cache data,