Tag Archives: ETL

Fragmented or Centralized Data

I read a piece recently that talks about the hassles of copying data multiple times for different applications. In my experience, I haven’t seen this to be the main problem with data. It’s not often that we might replicate, in … Continue reading

Posted in Editorial | Tagged , | 2 Comments

Self-Healing ETL

The process of building ETL flows is cumbersome and time consuming. Many consultants have made a lot of money by building ETL processes that manage the movement of data in and out of databases, including to data warehouses. There is … Continue reading

Posted in Editorial | Tagged ,

Importing Flat Files in SSMS 17.x Works

One of the more annoying things I’ve found in SSIS/SSMS is trying to import CSV files for some quick analysis. For some reason I constantly seem to get files that the import wizard keeps having issues. On top of that, … Continue reading

Posted in Blog | Tagged , , | 2 Comments

ETL or ELT

I was reading a piece on ETL patterns and found it interesting that the author noted that one way to reduce the challenge of ETL processes keeping up with changing schemas is to move to an ELT process. That’s an interesting perspective, and … Continue reading

Posted in Editorial | Tagged