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: )

942 reads

Blogs

Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers

By

Welcome back to my Power Platform Quick Tips series! In this second episode we...

Simple-Talk Article…Understanding Azure Storage Options

By

Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...

T-SQL Tuesday #120 – Recap

By

The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month. The post...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

https://texanssvs.com/colts

By pravacypolicY

https://texanssvs.com/colts https://texanssvs.com/colts-live/ https://texanssvs.com/colts-vs-texans/ https://texanssvs.com/texans-vs-colts https://texanssvs.com/colts-live-reddit/ https://livecoltsvs.com/texans/ https://livecoltsvs.com/texans-live/ https://livecoltsvs.com/colts-vs-texans/ https://livecoltsvs.com/texans-vs-colts https://livecoltsvs.com/texans-live-reddit//

Performance issue SSIS package from Oracle server

By alex.palmer

Hi We have a performance issue pulling data from an Oracle server into a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers