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


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


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

Simple-Talk Article…Understanding Azure Storage Options


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

T-SQL Tuesday #120 – Recap


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

Read the latest Blogs


Numeric and Decimal

By Steve Jones - SSC Editor

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


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


SQL Server Q&A from the SQLServerCentral community

Get answers