Alberto Ferrari's Blog

   View full profile
Page 8 of 77 blog posts
Blog post –

Distinct values in SSIS

Distinct is a partially blocking component that remove duplicates from one flow. Its main advantages against the sort component provided in SSIS are: Memory usage: Distinct does not cache the whole flow (as Sort does) but retains in memory only the distincts,  Read more

Blog post –

Visio does not handle Schema? Let’s force it to do!

I love VISIO to make database modeling, it gives very nice and colorful diagrams that I use for the documentation. I hate VISIO as it is really far from perfect, among all the others one thing it lacks is the ability to generate a database using SCHEMA  Read more

Blog post –

Data Flow Components, constructors and SSIS

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

Blog post –


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

Blog post –

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

Blog post –

Threads and custom components: FlowSync 1.0

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

Blog post –

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