THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » SQL Server » TableDifference   (RSS)
  • 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 several outputs for new, deleted, updated rows and so on. It is the classical ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on September 14, 2008
  • Table Difference 1.1

    TableDifference has been updated to version 1.1. The major improvement is the fact that now TableDifference can handle a field as Key: a field that represent a key in the table, you must supply KeyOrder Compare: a field that is to be compared between OLD and NEW, you must supply UpdateID PreferNEW: the field appear in both flows but you ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on July 6, 2006
  • TableDifference: a solution to SCD handling

    In SSIS the SCD component does a lot of work for you but it works so slowly that it is quite always convenient to create an “ad hoc” solution to handle the slowly changing dimensions. As the main problem is that of determining the difference between the last snapshot of the SCD and the current data we decided to write an SSIS component ...
    Posted to Alberto Ferrari (Weblog) by AlbertoFerrari on June 8, 2006
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement