Using BULK INSERT to insert rows from SQL Server dataset to table

by:
Roman Rehak

Learn how to use BULK INSERT to import all SQL Server dataset rows to a table.

Step 2 of 2:

Safe Harbor

I am importing data from a.xls file. First I took the data in the dataset and called the INSERT stored procedure. The problem is that while calling the INSERT stored procedure, the stored procedure is called to each row for the dataset. How can I use BULK INSERT for inserting all rows from a SQL Server dataset to a table?

You can use the SqlBulkCopy class in ADO.NET to quickly and efficiently load a SQL Server table from a DataTable object. For more details, read BULK insert to import data from file to SQL Server database.

This was first published in February 2008

Dig deeper on SQL Server Stored Procedures

All
News
Get Started
Manage
Problem Solve

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

E-Handbook

Developments in SQL Server BI point to focus on self-service, users

Related Q&A; from Roman Rehak, Contributor

Tips for tuning SQL Server 2005 to improve reporting performance

There are a few things you can do to tune SQL Server for improved reporting performance. Here are some generic and Reporting Services-specific ...continue reading

Storing and searching for image files in SQL Server

Learn about working with image files in SQL Server, including advice on using queries to locate them, in this expert answer.continue reading

Manipulate column names in a SQL Server table

Learn SQL Server commands to manipulate column names in a table and turn column names into variables or rename SQL columns.continue reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

Strategies for finding analytics skills, despite the shortage

The shortage of skilled analytics professionals is well documented, but SAS conference attendees said businesses that know where ...

Good grip needed on big data analytics tools, applications

Big data analytics could hold the key to future business success. But many organizations are still in the early stages of ...

To the rescue on business intelligence projects: The BI SWAT team

A fast-moving SWAT team of business intelligence specialists can resuscitate failing BI programs and help successful ones keep up...

SearchDataCenter

FC over Ethernet lowers costs by merging SAN/LAN data centers

Fibre Channel over Ethernet simplifies the data center and lowers costs by merging storage and data networks. And it doesn't take...

Dell privatization yields more of the same

It's been one year since Dell's private move. Here's what customers have seen so far and what they hope will improve.

IBM mainframe pricing gets a mobile discount

IBM offers a 60% discount on mainframe transactions from mobile devices. Here's how to segregate mobile CPU usage and get into ...

SearchDataManagement

Facebook experiment points to data ethics hurdles in digital research

A controversial Facebook research study that came to light this year provides fodder for discussions on the ethical issues ...

Spark framework gets big push from big data vendors

The Spark processing engine, which targets machine learning and a range of other big data analytics applications, was a big topic...

New developments make data integration a businesswide effort

Data integration software is now much more than just extract, transform and load tools -- it encompasses a wide range of ...

SearchAWS

Microsoft gains on Amazon as IT pros weigh AWS vs. Azure

AWS remains the 800-pound gorilla in cloud, but Microsoft Azure has something it doesn't: a preexisting relationship with ...

Docker, live migration top AWS re:Invent wish lists

AWS users hope to get live migration support, simpler cloud billing and new Docker integration at re:Invent.

Third-party tools pick up Amazon Redshift slack

Amazon's Redshift data warehouse offers speedy results on SQL queries, but an ecosystem of third-party tools is crucial for ease ...

SearchOracle

Converting historical data for an Oracle EPM redesign

Hoa Pham explains the last step in an Oracle EPM Hyperion consolidation redesign: converting the historical data. Go through the ...

Making and controlling change in your HFM application

Hoa Pham explains the importance of extracting metadata from HFM into Excel and how to track the changes as you redesign your HFM...

Get current or lose your Oracle DBA certification, Oracle says

Oracle has changed its policy on DBA certifications, retiring older ones and requiring database administrators to get current on...

SearchContentManagement

Weighing cloud-based ECM vs. file-sharing services

File-sharing services are challenging cloud-based ECM systems by providing basic, easy-to-use functionality. How will this ...

Microsoft, Dropbox join forces for mobile productivity apps

Microsoft and its former foe, Dropbox, join forces to make it easier to use productivity apps on mobile devices; and other ...

Mobile technology trends shake up enterprise collaboration

Mobile computing is taking over as real-time data becomes a must-have for businesses. How will mobility affect the way we work ...

SearchWindowsServer

Hidden vulnerabilities on your IIS 8 servers

IIS 8 isn't completely immune to security flaws. Here are some vulnerabilities you might be missing.

The significance of Windows Server in a changing IT landscape

Windows Server was once a dominant force in the IT landscape, but is now fighting for market share as more and more companies ...

Microsoft raises Azure profile, adds Dell cloud bundle

Microsoft tries cloud in a box again, only this time with Windows, Azure and servers from Dell.

SQL Server stored procedures vs. CLR stored procedures: Time to migrate?

Check SQL Server database and log file size with this stored procedure

Configure SQL Server Service Broker for sending stored procedure data

Find size of SQL Server tables and other objects with stored procedure

Saying yes, no or maybe to stored procedures

Why use stored procedures?

library

trigger

Change collation to SQL Server 2005 after upgrading databases

Stored procedures: Create and manage standard objects

Stored procedure: Examine children

Stored procedure: Investigate related data