I just opened the wiki on SQLBI.EU : it contains link to useful resources for BI solution development with SQL Server, so it covers SSIS, SSAS, SSRS and of course SQL Server itself. The wiki works well when there is large contribution, so please share  Read more

I just answered to a request on SQLBI.EU forum of someone that is looking for a better lookup component, specifically designed for typical Data Warehouse scenarios. While you can read the whole thread on the forum , I try to resume most wanted requirements,  Read more

SqlBulkTool is a command line utility that is used to quickly create a mirror of a database. It reads its configuration from an XML file containing source and destination command strings and a list of all the tables to mirror and then handles the work  Read more

Two weeks ago I wrote a tool to ease and improve the migration of a DTS package to a SSIS package. I named the tool DtsToSsis-Prepare, it is available with full source code at www.sqlbi.eu and now I wrote a larger article that describes the needs that  Read more

Thanks to Alberto Ferrari there is a new way to handle Slowly Changing Dimensions (SCD) with Integration Services: he just released Table Difference 1.1 and FlowSync 1.0 . Both are downloadable at www.sqlbi.eu . The problem that those components solve  Read more

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  Read more

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,  Read more

I wrote a small tool to improve the migration from SSIS to DTS. The problem I had to solve was this: I have many Data Transform Tasks that have a simple behavior, read data from a query and write data on a table, using fast load with batch insert. You  Read more

I had the opportunity to test TableDifference (a component written by Alberto Ferrari ) since early versions and I can say it is a very interesting way to handle Slowly Changing Dimension (SCD) much faster than with the standard SCD component of SSIS.  Read more

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  Read more