Technical Article

Load data from text file with variable columns

This script loads from a formatted text file (E.g. tab delimited) with variable number of columns using BULK INSERT. For instance, the file may have any number of columns and next load (seconds later) the same file may have a different number of columns. This script reads the first line (column names) extracting the names […]

You rated this post out of 5. Change rating

2005-03-01 (first published: )

991 reads

Blogs

Who Are You Doing It For?

By

But as I've matured over the years, I came to realize that I needed...

Presenting Twice in May 2026

By

I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...

Finding the Next Sequence Value: #SQLNewBlogger

By

I saw a question asking about the next sequence value and decided to try...

Read the latest Blogs

Forums

A Fun Computer Quote

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Fun Computer Quote

AI Database Central

By Steve Jones - SSC Editor

Comments posted to this topic are about the item AI Database Central

The Grafana Alternative to SSRS and Power BI

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Grafana Alternative to SSRS...

Visit the forum

Question of the Day

A Fun Computer Quote

Which movie featured this quote?

"All programs have a desire to be useful."
Happy April Fools!

See possible answers