BulkInsertTask Object (DTS)

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.

Methods
Execute Method  

Properties
BatchSize Property FormatFile Property
CheckConstraints Property KeepIdentity Property
Codepage Property KeepNulls Property
ConnectionID Property LastRow Property
DataFile Property MaximumErrors Property
DataFileType Property Name Property
Description Property RowTerminator Property
DestinationTableName Property SortedData Property
FieldTerminator Property TableLock Property
FirstRow Property  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.