Home > Articles > Data > SQL Server

  • Print
  • + Share This
From the author of

From the author of

Using Bulk Insert and BCP

You can use the T-SQL Bulk Insert Statement, the DTS Bulk Insert Task, or the BCP utility to import data. BCP is also available to export data. Depending on your situation and requirements, which one you use can have a big impact on performance and ease of use.

When you are importing text data that does not require transformations and it needs to participate in a process, use the Bulk Insert Task. The Bulk Insert Task is significantly faster than any other task in DTS. When you have minimal transformations, consider BCP or the T-SQL Bulk Insert Statement.

To export data that does not require transformations, use BCP. BCP can be three to six times faster than using DTS.

  • + Share This
  • 🔖 Save To Your Account