The BulkInsertTask object, based on the Transact-SQL BULK INSERT statement, provides the fastest method of copying large amounts of data from a text file to Microsoft® SQL Server™. Use BulkInsert task for copying operations, and in situations where performance is the most important consideration. It is not used in conjunction with transformations during data import operations.
Execute Method |