T-SQL – Read CSV files using OpenRowSet

We can directly access a CSV file using T-SQL.
Input file

Configure server to run Ad Hoc Distributed Queries
sp_configure 'Ad Hoc Distributed...

COOL Projects!

K-SSIS-ed A re-envisioned IDE for SSIS packages, jump here
SSDT Dev Pack A few helpers to make using SSDT slightly better, the killer feature for me is quickly deploying the...

COOL Projects!

K-SSIS-ed A re-envisioned IDE for SSIS packages, jump here
SSDT Dev Pack A few helpers to make using SSDT slightly better,...

COOL Projects!

K-SSIS-ed A re-envisioned IDE for SSIS packages, jump here
SSDT Dev Pack A few helpers to make using SSDT slightly better,...

Dealing with layered function calls

T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are...

On Failure: Getting Up

In my continuing series entitled “On Failure”, I want to talk about skiing.
I’m not a great skier. It would probably...

SSDT all the way

I generally write T-SQL code in SSDT (Sql Server Data Tools) and find that I often publish to my local database instance and then test the actual code in...

SSDT all the way

I generally write T-SQL code in SSDT (Sql Server Data Tools) and find that I often publish to my local...

SSDT all the way

I generally write T-SQL code in SSDT (Sql Server Data Tools) and find that I often publish to my local...

SSDT all the way

I generally write T-SQL code in SSDT (Sql Server Data Tools) and find that I often publish to my local...