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

Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s