Bulk insert for files with fixed-length or fixed-width fields in MS SQL

[finesoul]

• BULK INSERT (Transact-SQL)
  
• Using a Format File to Bulk Import Data
  
• Using a Format File to Map Fields to Columns During Bulk Import
  
• Working with Format Files
  
• Sample XML Format Files
  
• bulkloadschema.xsd
  You can add it like this
  

  <BCPFORMAT
         xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  	xsi:noNamespaceSchemaLocation="http://schemas.microsoft.com/sqlserver/2004/bulkload/format/bulkloadschema.xsd">
  
    <RECORD>
      <FIELD ID="FMSMK" xsi:type="CharFixed" LENGTH="1" />
  ...
    </RECORD>
    <ROW>
  ...
    </ROW>
  </BCPFORMAT>
  

  into the xml format file and visual studio will provide you with IntelliSense (VS will hwlp with allowed tags, attributes, values for attributes and etc)