SQLBI.EU offers a repository of tools and components useful to build a BI solutions with SQL Server.

Please register on SQLBI.EU site if you want to receive mail notifications when bug fixes and new releases will be available.

Download, try and give your feedback!

 

SSIS Components

TableDifference	Table difference is an SSIS custom component designed to simplify the management of slowly changing dimensions and – in general – to check the differences between two tables or data flow with SSIS. Its main advantage over Microsoft standard SCD component is its speed and ease of use, the component receives input from two sorted sources and generates different outputs for unchanged, new, deleted or updated rows.
FlowSync	FlowSync is a component that will make two or more flows of data in an SSIS data flow package run at the same speed, by stopping one flow if the others run too slow. It has been created as a convenient companion to TableDifference to resolve the problems with memory occupation, and it is useful when you have large amount of data processed by asynchronous components.
Distinct	Distinct is a partially blocking component that remove duplicates from one flow. Its main advantages against the sort component provided in SSIS are less memory usage, partially blocking component, fast performance.

Tools

DtsToSsisPrepare	DtsToSsis-Prepare is a command line tool that prepares a DTS package for a better migration to an SSIS package.
SqlBulkTool	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 of copying the database in an automated and highly parallelized way.
MdxScriptUpdater	MdxScriptUpdater is a simple C# class that simplifies updating MDX Scripts into a cube in a production environment.

Papers

Many-to-Many dimensional modeling

This project is not a tool or a component, but a set of design patterns to build solutions based on many-to-many dimension relationships with Analysis Services 2005. This area is almost unexplored and at the same time is full of opportunity. The paper is the synthesis of more than one year of experience on Analysis Services 2005, but it is only the beginning. More study and experience is needed, especially in performance evaluation.

SSAS Models

DateTool Dimension

DateTool is a special dimension containing regular members that act as calculated members similar to those generated by Time Intelligence Wizard (YTD, YOY%, ...), without some of the limitations of the wizard itself.