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 […]

2005-03-01 (first published: )

940 reads

Blogs

A simple powershell script to look up server hardware and OS information

By

This is a simple powershell script to query and display hardware and OS information...

Collecting Server Performance Metrics: Performance Monitor

By

Whether you’re a DBA/administrator looking to tune a server, planning for hardware updates, or...

Introduction to SQL Server Execution Plans

By

Watch this week’s episode on YouTube! I nearly always use execution plans as the...

Read the latest Blogs

Forums

How to send queued emails

By dubem1-878067

After an upgrade,   sql server stopped sending emails.   Problem is not solved but during...

TLS 1.2 and Database mail

By miapjp

Hi, We use office 365, and just recently received an email from them saying...

Left join not pulling all from left table

By jeffshelix

T has 57,000 distinct rows Z has over a million.  I did row over...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers