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 several outputs for new, deleted, updated rows and so on. It is the classical ...

CozyRoc has a suite of Control Flow Tasks that are worth a look. We're using the SFTP (Secure FTP) and SSH Connection Manager on my current project. Once we identified the need for SFTP, I looked around and identified a couple companies / products. The CozyRoc download was the only one I could make work. I've communicated with the ...

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 as usually freely available with sources as soon as it has been tested enough.

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 documentation about the changes at www.sqlbi.eu and all the sources and binaries ...

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 the end of the work the component does not clear them as I would expect the object to be ...

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, we know of it and now we decided to solve it creating a new component called ''FlowSync''. ...