GitHub

use-unicode-character-format-to-import-or-export-data-sql-server.md

The Unicode character data format allows data to be exported from a SQL Server instance by using a code page that differs from the code page used by the client. [!INCLUDESQL Server Azure SQL Database ...
GitHub

format-files-for-importing-or-exporting-data-sql-server.md

When you bulk import to a SQL Server table or bulk export from a table, a format file can store field format information for a data file relative to a table. [!INCLUDEssnoversion] supports two types ...
Ars Technica

Bulk Insert into Sql server?

Hello all. <BR>I have a collection of comma delimited text files sitting on a network drive. This data needs to be imported daily into our production tables. The destination tables vary depending upon ...
Ars Technica

Using non-printable char in MSSQL bulk import format file as delimiter

I've received a new file to import in our database and the *censored* DBA are the other end got creative with the format. he decided to use 0x01 as field delimiters and 0x02,0x0a,0x10 as record ...