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
- Con-way finds a way to run its outsourced IT services like a business
  
  Con-way faced new challenges when it decided to outsource IT services, such as tracking how the company utilizes data and infrastructure.
- Cloud, mobile top Gartner's list of big trends in business intelligence
  
  Mobile, social and cloud remain fairly hyped technologies for BI heading into 2013 along with that old standby -- information management.
- With mobile BI deployments, company size matters
  
  New survey results document how smaller businesses are leading the mobile BI charge.
Data Center
- Dell unveils workloads, features of converged infrastructure offering
  
  Dell bakes Gale Technologies' automation into Dell's Active Infrastructure to speed up deployments.
- Q&A;: New Dell Software group to offer data center management tools
  
  Dell plans software products surrounding data center management, "big data," business intelligence, security and data protection by 2014.
- Dell explains private cloud strategy, Quest Software plans
  
  Dell's cloud services strategy seeks to win over enterprises that want to build a private cloud first. It’s also got big plans for Quest Software.
Data Management
- Amazon set to upend status quo with Redshift data warehouse in the cloud
  
  Fast-moving Amazon.com will try to upend the conventional data warehouse software market with a low-cost, cloud-based warehousing service.
- With 'big data' out of the box, maintaining order is a must
  
  It’s easy to foretell continued growth in big data investments next year. But proper management and governance are needed to derive real business value from all that info.
- New Informatica Cloud update promotes business user self-service
  
  The winter release of Informatica Cloud aims to increase business user self-service capabilities while improving data quality.
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
- Pluggable Database virtualizes Oracle Database 12c
  
  Several users beta testing Oracle Database 12c say that Pluggable Database is one of its most powerful new features.
- JD Edwards upgrade: Consolidate EnterpriseOne business units
  
  Companies can consolidate their business units when doing a JD Edwards upgrade, but knowing how and when to do it isn't an easy task.
- How CTO Joel Gilbert built his own Exadata
  
  Gilbert, CTO of workforce management software company Pipkins, said he built Exadata before Oracle did. Well, kind of. See how he did it.
Content Management
- Content management strategy may be Lady Gaga's latest conquest
  
  Interscope records revamps its content management strategy with Echo's StreamServer to exploit social content created by fans of its musical artists.
- John Seely Brown: Knowledge flow becoming a new currency for business
  
  John Seely Brown on knowledge flow and organizational learning methods borrowed from gaming and surfing to help enterprises remain competitive.
- John Seely Brown explains organizational learning methods that work
  
  John Seely Brown discusses organizational learning methods that borrow from social networks to help enterprises compete in a new era.
Windows Server
- Final Patch Tuesday of the year brings fixes to Windows, Office, IE
  
  As 2012 draws to a close, Microsoft has one last batch of patches for admins. This month, Windows Server 2012, Office and Internet Explorer get fixes.
- Q&A;: System Center 2012 SP1 to deliver key management features
  
  Systems management expert Don Retallack offers details of next year's Microsoft System Center 2012 Service Pack 1.
- Easier DirectAccess setup means a plausible VPN alternative for admins
  
  DirectAccess used to be a complicated feature, but not anymore. In Windows Server 2012, simpler DirectAccess setup helps admins connect mobile users.

All Rights Reserved,Copyright 2005 - 2012, TechTarget