Ian Beckett

RSS feed

    Recent comments

    Authors

    TableDifference version 2.0 released!!

    I just caught this (almost a month late) but TableDifference 2.0 by Alberto Ferrari has been released!  This is a great custom component for SQL 2005 Integration Services.  It is used within a dataflow step and the component accepts two inputs; one for "old" data (the existing table) and another for "new" data (new incoming rows).  The component compares rows from the two streams and provides output paths such as "new", "updated", "deleted", "unchanged", as well as any custom outputs you define. 

     There were a number of bugs in version 1x that have hopefully been resolved in v2. I really look forward to using this tool!

    http://www.sqlbi.eu/ - home of TableDifference SSIS component

     Here is the official annoucement:

    Table Difference 2.0 is ready

    Guys,

    The new version 2.0 of TableDifference is finished and available in the download area.

    The zip file contains both the DLL and complete sources. Moreover, in the sources folder there is a README.DOCX document that explains how to use the new features of the component, so I will not discuss them here.

    Main features are:

    User interfaces completely rewritten and made much more user-friendly
    Ability to disable output flows and/or single columns in the outputs
    Ability to ignore case in string comparisons
    Some speed improvement (haven't tested it carefully but it seems faster. :))
    Have a good download and don't be afraid to ask if something is going wrong.

    Alberto


    Posted by ibeckett on Monday, March 31, 2008 3:08 AM
    Permalink | Comments (0) | Post RSSRSS comment feed

    Related posts