Using DataDirect Bulk Load on Microsoft SQL Server
- Last Updated: April 16, 2026
- 1 minute read
- ADO.NET
- Documentation
DataDirect Bulk Load offers a one-stop approach for all of your bulk load needs, with a simple, consistent way to do bulk load operations for all of the DataDirect Connect products that support this feature (see Using DataDirect Bulk Load).
Limitations
The SQL Server data provider has no special requirements or limitations for bulk load operations.
Native to XML Schema Data Type Mappings
The following table shows how native SQLServer DbTypes are mapped to XML schema data types for the bulk load configuration file.
Mapping SQLServerDbType Enumerations to XML Schema Data Types
| SQLServerDbType Enumerations | XML Schema Data Types |
| Bigint | Bigint |
| Binary | Binary |
| Bit | Bit |
| Char | Char |
| Datetime | Datetime |
| Decimal | Decimal |
| Float | Double_precision |
| Image | Longvarbinary |
| Int | Integer |
| Money | Decimal |
| NChar | Unicode_char |
| Ntext | Unicode_longvarchar |
| Numeric | Decimal |
| Nvarchar | Unicodevarchar |
| Ntext | Unicode_longvarchar |
| Real | Single_precision |
| Smalldatetime | DateTime |
| Smallint | Smallint |
| Smallmoney | Decimal |
| Text | Longvarchar |
| Timestamp | DateTime |
| Tinyint | Unsignedtinyint |
| Unichar | Unicode_char |
| Unitext | Unicode_longvarchar |
| Uniqueidentifier | Guid |
| Varbinary | Varbinary |
| Varbinarymax | Varbinary |
| Varchar | Varchar |
| Variant | Unicode_longvarchar |
| Varbinary | Varbinary |
| Xml | Xml_text |