BULK INSERT multiple Files in SQL SERVER Express

This post comes from this MSDN Forum question.

Because of use SQL SERVER Express, we cannot use Integration Services(SSIS).

Therefore, we  have two choices:

  1. BULK INSERT
  2. OPENROWSET(BULK…)

In each statement you can insert only one column with above choices. Erland Sommarskog was provided a solution to insert multiple files in this link:

Bulk Insert Multiple Files (TSQL)

For more information you can also see this great article:

Bulk Inserts via TSQL in SQL Server

Advertisements