Tag Archives: ETL

Loading a Text File with a Line Feed

Posted on February 3, 2016 by way0utwest

Loading text files is a skill that probably every DBA needs. I know that the import wizard is available, but there are times that you might want to automate this without using SSIS. In those cases, it’s nice to know … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

When Should We Be Cleaning Data?

Posted on June 8, 2015 by way0utwest

I was reading Grant Fritchey’s update from the Business Analyst Conference  and noticed this quote: ” There were lots of sessions on the need to clean data, which implies that we need to do a better job at data collection in order … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on When Should We Be Cleaning Data?

Opening Up Data

Posted on May 12, 2015 by way0utwest

Tim O’Reilly has been an advocate of open data access and standards for some time, especially from governments. He’s pushed for more interoperability and certainly more accessability from all sorts of groups. He gave an interview earlier this year to LinuxVoice where … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Opening Up Data

ETL

Posted on November 4, 2011 by way0utwest

Today we have an editorial that was originally published on Aug 31, 2006 as Steve is traveling at DevConnections. I’ve followed the development, release, and subsequent news on SQL Server 2005 for over two years now. It’s been an interesting … Continue reading →

Posted in Editorial | Tagged , | Comments Off on ETL