DTSBulkInsert_DataFileType Enumeration

 

Defines the type of file that provides the source data.

Namespace:   Microsoft.SqlServer.Dts.Tasks.BulkInsertTask
Assembly:  Microsoft.SqlServer.BulkInsertTask (in Microsoft.SqlServer.BulkInsertTask.dll)

public enum class DTSBulkInsert_DataFileType

Member nameDescription
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.

No code example is currently available or this language may not be supported.

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

Return to top
Show: