Category: DTS

Dimensional Drift

13 October 2016 The Proud Salopian Data Services, Data Warehouse, Dimensional Database, Dimensions, DTS, ETL, SAP, Slowly Changing Dimensions, Technical, Transformations

I find myself starting this blog, sad that I must write it. When it comes to development languages and products

ETL: How to consume result sets in DTS

31 May 2016 The Proud Salopian Data Warehouse, Database, DTS, Technical

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

Coping with Large Dimensional Workflows

12 October 2015 The Proud Salopian Data Warehouse, Dimensional Database, Dimensions, DTS, Facts, RDBMS, SQL, SqlServer, SSIS, Technical

I have recently been working on a third tranche of ETL work for a client which is basically a reasonably

Lookup Date Values in DTS package

6 October 2015 The Proud Salopian Dates, DTS, Lookups, SSIS, Technical, Transformations

I recently came to extend some DTS packages that we have implemented for a client to include a LOT of

Search for: