title: Importing *.DAT file into SQL server
body: <p>I am trying to import *.DAT file(as flat file source) into sql server using SQL server import and export wizard. It has DC4 as delimiter which is causing error while trying to separate the columns and their respective data and importing them in sql server.</p>
  
  <p>Are there any setting changes to be made during the importing process?</p>