Data files containing comma separated values, or CSV, are some of the most common data formats used for data representation and storage outside the database. When it comes to loading CSV data into the database, many options exist, however, few make it as simple as CSVexpress, powered by expressor software. I recently visited www.csvexpress.com to check out just how simple it could get. In short, CSVexpress offers a repeatable and quick way to load any CSV file into SQL Server (or any other database). For those whose data quality is not as pristine as it should be, CSVexpress also offers … [Read more...]
Simplifying CSV Data Loads
Filed Under: Administration, Cool Technologies, Databases, SQL Server, SQLMag, SQLServerPedia Syndication, Tips & Tricks Tagged With: Data Cleansing, Data Quality, DBA, ETL, Master Data Management, SQL Server 2008
ETL Demo with Data From Data.Gov
A little over a month ago, I wrote an article (Is There Such a Thing as Easy ETL) about expressor software and their desktop ETL application, expressor Studio. I wrote about how it seemed much easier than the native ETL tools in SQL Server when I was reading up on the tool, but that the "proof would be in the pudding" so to speak when I actually tried it out loading some free (and incredibly useful) data from the US federal data clearinghouse, Data.Gov. If you'd rather not read my entire previous article - quick recap, expressor Studio uses “semantic types” to manage and abstract mappings … [Read more...]
Filed Under: Administration, Cool Technologies, Databases, On-Line Resources, SQL Server, SQLMag, SQLServerPedia Syndication, TCD blog post, Tips & Tricks Tagged With: Data Cleansing, Data Quality, DBA, ETL, Master Data Management, SQL Server 2008 R2