Importing a CSV into SQL Server Shouldn’t Be This Hard

Like many of you, I recently had to import some data in a CSV (comma-separated file) into SQL Server. This wasn’t a new process, or an application that needed enhancing, or even an ongoing ETL (Extract, Transform, Load) process that needed to be built. This was an ad hoc, semi-one-off request. It’s a similar type of request that I’ve had come across my desk over the years from many sources. Whether I was a DBA or developer, often someone gets a little data and wants it cleaned up and in a structured format to easily run a report or analyze