4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London


Paul te Braak


Paul te Braak is the principle consultant of abaX Data and has over a decade of experience in delivering reporting and business intelligence solutions across a variety of verticals.  This experience includes systems auditing, planning and business simulation models that predict activity through heuristic rules imbedded into the model.  He holds several qualifications including MCT, CA, MIT, MComm.

http://www.paultebraak.wordpress.com http://paultebraak.wordpress.com/feed/

Blog posts RSS

Biml XII – Oledb Command (Dataflow transformation) 17 Dec 2014
The data flows OLEDB Command executes an SQL statement for each row of the data flow. A good example of its use is the update of expired records end dates for type 2 changed dimensions. I’ve briefly discussed the logic for roll your own type 2 (changing) attributes here with the need to ...

Biml XI – Conditional Splits in Data Flows 17 Dec 2014
At first thought, I don’t see a huge need for conditional splits in SSIS, separating the stream (as it were) is something that I usually try and do at the source. That is, we should only bring in as much data as is required by the transform. However, in thinking about it, the transform is ...

Biml X – Derived Columns 10 Dec 2014
This post looks at the biml requirements and functionality of derived columns – how to apply logic to a column (replace a value) and add new columns. The scenario is pretty simple and builds on our other concepts of but now includes a little more ‘business logic’ (albeit simple) so we ...

Biml IX – The Lookup 07 Dec 2014
Our previous posts biml data flows have only included extractions and destinations. We have looked at moving data (the relation way) here and error configuration here. These posts have set the framework for discussing other dataflow transformations that are commonly used. Perhaps the most common of ...

BIML VIII – Managing Errors in Data Destinations (ADO Destination) 02 Dec 2014
In a previous post we looked at the biml required to send data to an ODBC destination. Relational destinations are the bread and butter of SSIS (well the work I do anyway) and one of the most common ways to manage insert errors is to redirect the dataflow two or more forgiving destination. This ...