SQL-only ETL using a bulk insert into a temporary table (SQL Spackle)

http://ift.tt/1loNjqB

This article demonstrates a method of importing a data file directly into a temporary table and selectively inserting data from the temporary table into a SQL Server table, all in a single set of SQL commands.

from SQLServerCentral.com Articles http://ift.tt/Y4GoHZ