O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Batch insertion of data into a database: Bulk Insert Task

Bulk Insert is used in scenarios where a large volume of data should be quickly inserted into a destination database. There are several ways to deal with this under SSIS but the difference will be in the speed of inserting such volumes of data into a database. This approach is used to ensure speed while copying data or performing transformations while the data is moving.

Some constraints should be considered before using this approach:

  • Data must be transferred from a text file to an SQL Server table or view.
  • The destination must be a table or view in an SQL Server database.
  • Only members of the sysadmin fixed server role can execute a package with this task.

Getting ready

Make sure that the database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required