Open topic with navigation

DMExportDataFormat Enumeration
Alterian Email Manager 6.2.3 SDK Help File
Available formats

Namespace:  DMLibrary
Assembly:  DMLibrary (in DMLibrary.dll) Version: 1.0.6340.17420

Syntax
Copy
public enum DMExportDataFormat
Members
Member nameValueDescription
DMDF_CSV0Comma separated values
DMDF_BCP1Bulk Copy Program (native MSSQL data file)
Remarks
DMDF_CSV
  • Only string data is enclosed in quotes
  • Quotes within quoted strings are doubled
  • NULL values are completely blank whereas empty strings are ""
  • Character format is UTF-8
  • No header row is included
DMDF_BCP
  • Nullable and variable size values are always prepended by their length, length of -1 indicates a null value
  • The number of length bytes depends on the datatype: 2 bytes for varchar, 4 bytes for text, 1 byte for everything else
  • Datetime is stored in 8 bytes: 1st 4 bytes is days since 1900-01-01, 2nd 4 bytes is ticks since midnight (1 tick = 3.333 milliseconds)
  • Smalldatetime is stored in 4 bytes: 1st 2 bytes is days since 1900-01-01, 2nd 2 bytes is minutes since midnight
BCP output can be loaded directly into SQL tables:
bulk insert table_name from 'data_file' with (datafiletype='native')
See Also