Home
Topics
Microsoft SQL Server Administration
SQL Server Stored Procedures
Using BULK INSERT to insert rows from SQL Server dataset to table

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

Roman Rehak, Contributor

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?

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

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.

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- library
- trigger

This was first published in February 2008

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

Back to top

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- Enterprise Data World reveals nine principles of analytics rock stars
  
  At Enterprise Data World 2013, consultant Bernard Wehbe detailed what sets indispensable analytics professionals apart from the rest of the crowd.
- Eckerson: Self-service business intelligence not a give-and-go affair
  
  In an interview, TechTarget's Wayne Eckerson explains why there's more to self-service BI success than putting tools in the hands of business users.
- Get execs to get it on the business value a BI program can bring
  
  Backing from top executives can be crucial on business intelligence projects, and BI managers shouldn't shy away from the challenge of getting them on board.
Data Center
- PUE metric helps keep data center energy use in check
  
  The PUE metric helps smaller enterprises measure data center energy use to determine if various efficiency initiatives are worth pursuing.
- How does a Bloom Energy Server convert fuel into power?
  
  Some enterprises have cut their electric bill by plugging commercial fuel cell systems, like Bloom Energy Servers, into their data center.
- How to perform due diligence on sources of used IT equipment
  
  Used IT equipment can help a business cut capital costs, but be proactive to protect yourself from dishonest gray-market sellers.
Data Management
- Analytical database tech at core of Actian-ParAccel deal, Pivotal plan
  
  The EMC-VMware launch of Pivotal and Actian's ParAccel buy share a theme: Both feature analytical databases and play to the big data trend.
- Enterprise Data World preview: Karen Lopez offers tips for data modelers
  
  Enterprise Data World 2013 kicks off next week in San Diego. We talked to consultant and conference speaker Karen Lopez to find out what to expect.
- Marketing company uses in-database analytics to fight customer churn
  
  Trident Marketing is running analytical models on a data warehouse appliance to help keep consumers hooked on satellite TV service and other products.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- Rich Niemiec on Oracle database 12c, database security and Larry's law
  
  We caught up with Rich Niemiec at Collaborate 13. Listen to his observations on such topics as Oracle database 12c and more.
- Installing Oracle Fusion Applications an integration challenge
  
  Find out how one user solved the problem that arises when installing Oracle Fusion applications and trying to integrate them with non-Fusion apps.
- MedicAlert EBS implementation helped by 'PUMA' system
  
  MedicAlert set forth a PUMA -- short for Phenomenal Undertaking at MedicAlert -- system to speed along its EBS implementation and get employee buy-in.
Content Management
- SharePoint technology feels growing pains as 2013 release arrives
  
  SharePoint 2013 adds new features to the collaboration software. But it comes at a time when SharePoint's value is being questioned in some quarters.
- SharePoint 2013 release puts upgrade issues back in the spotlight
  
  With the arrival of SharePoint 2013, IT managers and SharePoint admins have new upgrade considerations to weigh as they evaluate possible deployments.
- 'No IT' technologies empower business users, improve productivity
  
  Self-service tools that can be deployed without IT's assistance are changing the relationship between IT pros and end users, to their mutual benefit.
Windows Server
- Windows Azure Active Directory steps out of the shadows
  
  As Windows Azure Active Directory moves into general availability, we look at how it can help admins manage user authentication in the cloud.
- Steps to read XML files with PowerShell
  
  Wondering how to get PowerShell to read XML files? Our expert explains a few methods you could use.
- When to use a PowerShell workflow
  
  A PowerShell workflow may be one of the most talked about features in PowerShell v3, but that doesn't mean admins know how to use it.

All Rights Reserved,Copyright 2005 - 2013, TechTarget