I find myself starting this blog, sad that I must write it. When it comes to development languages and products I am without a shadow
Category: DTS
ETL: How to consume result sets in DTS
So… about a month ago I was involved in a very complex DTS package. Amongst other things it involved looping through result sets of data, assigning the values found within each row
Coping with Large Dimensional Workflows
I have recently been working on a third tranche of ETL work for a client which is basically a reasonably complex data warehouse. Its been
Lookup Date Values in DTS package
I recently came to extend some DTS packages that we have implemented for a client to include a LOT of new Date styled dimensions. You
The Proud Salopian 