DTSBulkInsert_DataFileType Enumeration
Defines the type of file that provides the source data.
Assembly: Microsoft.SqlServer.BulkInsertTask (in Microsoft.SqlServer.BulkInsertTask.dll)
| Member name | Description | |
|---|---|---|
| DTSBulkInsert_DataFileType_Char | Character format (default value). | |
| DTSBulkInsert_DataFileType_Native | Native (database) data types. Create the native data file by bulk copying data from SQL Server using the bcp utility. | |
| DTSBulkInsert_DataFileType_WideChar | Unicode characters. | |
| DTSBulkInsert_DataFileType_WideNative | Native (database) data types, except in char, varchar, and text columns, which store data as Unicode. Create the widenative data file by bulk copying data from SQL Server using the bcp utility. |
The Bulk Insert task provides the quickest way to copy large amounts of data into a SQL Server table or view. For more information, see Bulk Insert Task and bcp Utility.
The following example creates a BulkInsertTask, then shows the default settings of the properties, using the TaskHost. It then sets two fields, one of them being the DataFileType, which uses this enumeration, to show how to set field values.
Sample Output:
BatchSize 0
CheckConstraints False
CodePage RAW
DataFileType 0
DebugMode False
DestinationConnection
DestinationTableName
FieldTerminator Tab
FireTriggers False
FirstRow 1
FormatFile
KeepIdentity False
KeepNulls False
LastRow 0
MaximumErrors 0
RowTerminator {CR}{LF}
SortedData
SourceConnection
SqlStatement System.String[]
SuspendRequired False
TableLock False
UseFormatFile False
--------------------------
New value of CheckConstraints and DataFileType: True, 1