title: BCP IN error : [Microsoft][SQL Server Native Client 10.0]Unexpected EOF encountered in BCP data-file
body: <p>BCP IN issue in SQL server 2008.</p>
  
  <p>Trying to BCP in from .CSV to sql server 2008 table using batch script.</p>
  
  <p>Not using any format file but used the delimiter pipe.</p>
  
  <p>And also .CSV file consists of comma seperator when opened in the notepad++</p>
  
  <p>Getting the below error:</p>
  
  <pre><code>BCP Output: 
  Starting copy...
  SQLState = S1000, NativeError = 0
  Error = [Microsoft][SQL Server Native Client 10.0]Unexpected EOF encountered in BCP data-file
  
  0 rows copied.
  Network packet size (bytes): 4096
  Clock Time (ms.) Total     : 1  
  </code></pre>