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
sysadminfixed server role can execute a package with this task.
Getting ready
Make sure that the database created exclusively for this book is available in the SQL Server Management Studio (SSMS). For more information about this database, refer to the chapter's introduction.
In this recipe the Customers table from the PacktPub database sample will...
